|
The UPDATE Statement: Used to change values in one or more columns in a table.
|
|
Syntax: UPDATE table-or-query
|
|
SET column1=expression1[,column2=expression2][,..]
|
|
[WHERE criteria];
|
|
Example: UPDATE tblMenu SET tblMenu.Price = {Price]*1.1 WHERE MenuDescription Not Like "*Pizza";
|
|
The DELETE Statement: Used to delete rows from tables.
|
|
FROM from-clause
|
|
[WHERE criteria];
|
|
Example: DELETE FROM tblMenu WHERE Discontinued = True;
|
|
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.
|
|
Syntax: INSERT INTO target-table
|
|
select-statement;
|
|
Example: INSERT INTO tblCustomer SELECT * FROM tblCustomerNew;
|
