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

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


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')


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.


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.