Friday 26 July 2013

To create a new record in a mysql database:

INSERT INTO table_name VALUES (value1, value2, value3,...)
If one or more fields are auto update, put NULL in the values list.
Else, use this syntax
INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

No comments:

Post a Comment