| 1 |
The UPDATE Statement: Used to change values in one or more columns in a table.
|
| 2 |
Syntax: UPDATE table-or-query
|
| 3 |
SET column1=expression1[,column2=expression2][,..]
|
| 4 |
[WHERE criteria];
|
| 5 |
Example: UPDATE tblMenu SET tblMenu.Price = {Price]*1.1 WHERE MenuDescription Not Like "*Pizza";
|
| 6 |
The DELETE Statement: Used to delete rows from tables.
|
| 7 |
FROM from-clause
|
| 8 |
[WHERE criteria];
|
| 9 |
Example: DELETE FROM tblMenu WHERE Discontinued = True;
|
| 10 |
The INSERT INTO Statement: Used to copy rows from one table into another or to add a single row of data to a table using a list of values.
|
| 11 |
Syntax: INSERT INTO target-table
|
| 12 |
select-statement;
|
| 13 |
Example: INSERT INTO tblCustomer SELECT * FROM tblCustomerNew;
|
