How do auto increment in Mysql without declaring columns in INSERT?

Question

I noticed that when I have a column with auto_increment, I have to declare the columns on INSERT.

For example, I created this test table:

create table teste(
id int auto_increment,
nome varchar(100) not null,
valor decimal(5,2),
constraint id_pk primary key (id));

I wanted to be able to enter the data without declaring the columns, as in this example:

insert into teste values ('Danilo',333.33)

But he does not understand, and in the end I have to declare so:

insert into teste (nome,valor) values ('Danilo',333.33)

My question is whether I can make one INSERT without declaring all columns, like using a reserved word or something that Mysql understands.

Answer 1

Since you are using a positional syntax with all columns you have to send values to all columns. And since you do not want to send to the first column, send a null. Since it has an automatic default value this value will be placed in place of the null.

insert into teste values (null, 'Danilo',333.33)

Behold working in the SQL Fiddle. Also put on the Github for future reference.

If you find it bad there the output is the one you already found, use the syntax of named arguments not to consider the position of each column.