insert into values where mysql code example
Example 1: Insert mysql
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
INSERT INTO table_name
VALUES (value1, value2, value3, ...);
Example 2: mysql insert
INSERT INTO table1 (col1, col2) VALUES (3, 'A string');
INSERT INTO table1 (col1) VALUES (3);
INSERT INTO table1 VALUES (3, 'A string');
INSERT INTO table1 (col1, col2) SELECT value3, value1 FROM table2;
Example 3: insert mysql
INSERT INTO tbl_name (a,b,c)
VALUES(1,2,3), (4,5,6), (7,8,9);