PHP mySQL - Insert new record into table with auto-increment on primary key

Question

Wondering if there is a shorthand version to insert a new record into a table that has the primary key enabled   i e  not having to include the key column in the query  Lets say the key column is called ID  and the other columns are Fname  Lname  and Website   query    INSERT INTO myTable VALUES   Fname    Lname    Website

User · Answer

query    INSERT INTO myTable VALUES  NULL  Fname    Lname    Website       Just leaving the value of the AI primary key NULL will assign an auto incremented value

User · Answer

Use the DEFAULT keyword    query    INSERT INTO myTable VALUES  DEFAULT  Fname    Lname    Website       Also  you can specify the columns   which is better practice     query    INSERT INTO myTable            fname  lname  website            VALUES             fname    lname    website       Reference    http   dev mysql com doc refman 5 6 en data-type-defaults html

User · Answer

I prefer this syntaxis    query    INSERT INTO myTable SET fname  Fname  lname  Lname  website  Website

User · Answer

This is phpMyAdmin method    query    INSERT INTO myTable           mtb i idautoinc  mtb s string1  mtb s string2            VALUES           NULL   Jagodina    35000

User · Answer

You can also use blank single quotes for the auto increment column  something like this  It worked for me    query    INSERT INTO myTable VALUES      Fname    Lname    Website

[php] PHP mySQL - Insert new record into table with auto-increment on primary key

Examples related to php

Examples related to mysql

Examples related to insert

Examples related to auto-increment