PHP mySQL - insert a new record into a table with automatic increment by primary key

Question

Want to know if there is an abridged version for inserting a new record into a table with the primary key turned on? (i.e. do not include the key column in the query) Assume that the key column is called ID, and the remaining columns are Fname, Lname and Website

$query = "INSERT INTO myTable VALUES ('Fname', 'Lname', 'Website')"; 

Answer 1

Use the DEFAULT keyword:

 $query = "INSERT INTO myTable VALUES (DEFAULT,'Fname', 'Lname', 'Website')"; 

Alternatively, you can specify columns (which is better):

 $query = "INSERT INTO myTable (fname, lname, website) VALUES ('fname', 'lname', 'website')"; 

Link:

• http://dev.mysql.com/doc/refman/5.6/en/data-type-defaults.html

Answer 2

I prefer this syntax:

 $query = "INSERT INTO myTable SET fname='Fname',lname='Lname',website='Website'"; 

Answer 3

 $query = "INSERT INTO myTable VALUES (NULL,'Fname', 'Lname', 'Website')"; 

Just leave the primary key value AI NULL and assign an automatically incremented value.

Answer 4

This is the phpMyAdmin method.

 $query = "INSERT INTO myTable (mtb_i_idautoinc, mtb_s_string1, mtb_s_string2) VALUES (NULL, 'Jagodina', '35000')";