mysql insert where code example
Example 1: myql insert from select
INSERT INTO table_name(column_list)
SELECT
select_list
FROM
another_table
WHERE
condition;
Example 2: Insert mysql
#Some columns or all
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
#All columns
INSERT INTO table_name
VALUES (value1, value2, value3, ...);
Example 3: insert mysql
INSERT INTO tbl_name (a,b,c)
VALUES(1,2,3), (4,5,6), (7,8,9);