SQL for modifying data

This section takes you through some example syntax for modifying data in MySQL. For more details on this syntax, visit Chapter 8, Modifying Data and Table Structures. This chapter will also outline the differences in syntax for Oracle, PostgreSQL, and SQL Server.

Syntax for inserting data

To INSERT a single row, you can use the following sample syntax:

INSERT INTO tablename (col1, col2, col3)
VALUES ('value1','value2',value3);

To INSERT multiple rows, you can use the following sample syntax:

INSERT INTO tablename (col1, col2, col3)
VALUES ('value1','value2',value3),
       ('value5','value6',value7),
       ('value8','value9&apos...