Which insert is better?

[The Little Guy]

I know of two ways write an sql insert,

 

insert into table a (1,2,3) values (1,2,3);

or

insert into table a set 1=1, 2=2, 3=3;

 

is one of the way deprecated, and/or is one better than the other?

[sunfighter]

When you don't specify the column names where the data will be inserted you should be inserting into all the columns:

INSERT INTO table_name VALUES (value1, value2, value3,...)

 

If your going to specify the column names use this form:

INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

 

The last form is good when your not inserting into all columns, but also works as a replacement for the first form.

 

 

[gizmola]

The first form is the most standard across different RDBMS.

[The Little Guy]

okay.

 

when was the second method introduced into MySQL?

[fenway]

It was probably a backwards-compatibility issue... but the first one is preferred for multi-valued options.