How to insert new row to database with AUTO INCREMENT column without specifying column names

Question

I have a table with the following columns    id - INT UNSIGNED AUTO INCREMENT name - VARCHAR 20  group - VARCHAR 20    I know that I can add a row like this   INSERT INTO table name  name  group  VALUES   my name    my group     I wonder if there is a way to add a row without specifying the column names  like when there is no AUTO INCREMENT column

User · Accepted Answer

For some databases  you can just explicitly insert a NULL into the auto increment column   INSERT INTO table name VALUES  NULL   my name    my group

User · Answer

Just add the column names  yes you can use Null instead but is is a very bad idea to not use column names in any insert  ever

User · Answer

Even better  use DEFAULT instead of NULL  You want to store the default value  not a NULL that might trigger a default value   But you d better name all columns  with a piece of SQL you can create all the INSERT  UPDATE and DELETE s you need  Just check the information schema and construct the queries you need  There is no need to do it all by hand  SQL can help you out

[sql] How to insert new row to database with AUTO_INCREMENT column without specifying column names?

Examples related to sql

Examples related to mysql

Examples related to insert

Examples related to auto-increment