How to insert, update, and delete data

The syntax for the INSERT statement

INSERT INTO table-name [(column-list)] VALUES (value-list);

A statement that adds one row to a table

INSERT INTO products (categoryID, productCode, productName, listPrice)
VALUES (1, 'tele', 'Fender Telecaster', 599.00);

A statement that uses the MySQL NOW function to get the current date

INSERT INTO orders (customerID, orderDate) 
VALUES (1, NOW());

The syntax for the UPDATE statement

 UPDATE table-name 
 SET expression-1 [, expression-2] ... 
 WHERE selection-criteria;

A statement that updates a column in one row

UPDATE products 
SET productName = 'Ludwig 5-Piece Kit with Zildjian Cymbals' 
WHERE productCode = 'ludwig';

A statement that updates a column in multiple rows

UPDATE products SET listPrice = 299 WHERE categoryID = 1;

The syntax for the DELETE statement

DELETE FROM table-name 
WHERE selection-criteria;

A statement that deletes one row from a table

DELETE FROM products 
WHERE productID = 1;

A statement that deletes multiple rows from a table

DELETE FROM products 
WHERE listPrice > 200;

    Description
Since the INSERT, UPDATE, and DELETE statements modify the data that’s stored in a database, they’re sometimes referred to as action queries. These statements don’t return a result set. Instead, they return the number of rows that were affected by the query.

Back