Tuesday, November 19, 2013

Insert into table values and insert into table set in MySQL




Insert into table values and insert into table set in MySQL are identical.
Example
INSERT INTO table_1 (a, b, c) VALUES (1,2,3)
is the same as
INSERT INTO table_1 SET a=1, b=2, c=3

No comments:

Post a Comment