Answers for "mysql insert where"

myql insert from select

INSERT INTO table_name(column_list)
SELECT 
   select_list 
FROM 
   another_table
WHERE
   condition;

Posted by: Guest on June-24-2020

insert mysql

INSERT INTO tbl_name (a,b,c) 
    VALUES(1,2,3), (4,5,6), (7,8,9);

Posted by: Guest on May-05-2020

insert into mysql

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

Posted by: Guest on May-02-2021

Code answers related to "mysql insert where"