MySQL Tutorial Insert Update Delete 32 codes

  1. Home
  2. MySQL Tutorial
  3. Insert Update Delete
1 Change multiple columns using one statement
2 Commit a transaction
3 Copying Tables with auto_increment column
4 Create a save point
5 Delete on row with LOW_PRIORITY
6 Delete statement based on table joins
7 Delete statement based on table joins (tableName )
8 Do calculation in the insert statement referencing the column name
9 Insert aTable into select from anotherTable
10 Insert double quotation mark by using the single quote
11 Insert more than one rows in a single insert statement
12 Insert NULL to a NOT NULL column
13 Insert quotation marks
14 Insert single quotation mark by using the double quote
15 Insert statement with set statement and default value
16 Insert two rows with one insert statement
17 Insert with set statement
18 INSERTing data
19 REPLACE INTO
20 Rollback a transaction
21 Rollback to the save point
22 Syntac for UPDATE statement
23 The DELETE statement
24 Update a value based on the value it currently holds
25 Update only 5 records
26 Update two tables in one update statement
27 UPDATE-ing Records
28 Use the DEFAULT in the insert statement
29 Use the LIMIT function to control the number of rows that are affected by your UPDATE statement
30 Using encode function with insert statement
31 Using the LIMIT keyword to ensure only the number of rows you specify are deleted
32 Without the WHERE clause, all records from the database are deleted by default