mysql insert in to statement

[ganeshp]

Hi All,

INSERT INTO tab_name (ID,NAME) VALUES (0,"zero" );
INSERT INTO tab_name (ID,NAME) VALUES (1,"one" );

Can the above two statements be combined in to just one INSERT INTO statement

Please help

[Stang02GT]

Hi All,

INSERT INTO tab_name (ID,NAME) VALUES (0,"zero" );
INSERT INTO tab_name (ID,NAME) VALUES (1,"one" );

Can the above two statements be combined in to just one INSERT INTO statement

Please help

I believe you will need to keep them separate but you can have one insert for the NAMES and one insert for the ID's

INSERT INTO Table Name (ID) VALUES(0,1,2)
INSERT INTO Table Name (Name) VALUES ("zero", "one", "two")

[r035198x]

values(1, 2),  (4, 5), (6,7);

Check the refmanual.

[ganeshp]

thank you very much

Regards,
Ganesh

[r035198x]

Welcome, always refuse to write a single line of sql without the refmanual.