suppose i have a table table1 with columns col1, col2, auto, with auto being auto-incrementing

every time I want to add a row I have to use the statement specifying the columns

insert into table1 values (col1, col2) values (val1, val2)

instead if I want to use the statement below without specifying col names -

insert into table1 values (col1, col2, col3)

Is there a dummy value. reserved word that I can specify for col3 ?

yes, there is

this dummy word is NULL