Answers for "insert into select mysql query"

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 select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Posted by: Guest on June-30-2020

Code answers related to "insert into select mysql query"