MySQL Insert


INSERT INTO

The INSERT INTO syntax is used to add data records to a data table.

grammar:

INSERT INTO tb_name VALUES (value1, value2, ...)

This syntax means to insert data records into all the fields in the table in order.

But in many cases add a record to the specified column:

INSERT INTO tb_name (column1, column2, ...) VALUES (value1, value2, ...)
Note

In the SQL statement, we use the single quotation mark '' to represent the text character attributes




Copyright 2014-2017 by DeveloperTut.com. All Rights Reserved.
TwitterGoogle+Facebook