Current course:

MySQL insert statement


Description:

An "insert" statement is used to insert or add something into a table.

The Code:

INSERT INTO table (field1, field2, field3) VALUES ('value1', 'value2', 'value3')

Or, in php: mysql_query("INSERT INTO table (field1, field2, field3) VALUES ('value1', 'value2', 'value3')");

Notes

You do not use WHERE or LIMIT with an INSERT statement.