Answers for "how to copy a row into another table mysql"

copy data from one table to another mysql

INSERT INTO table2 (st_id,uid,changed,status,assign_status)
SELECT st_id,from_uid,now(),'Pending','Assigned'
FROM table1

Posted by: Guest on June-06-2021

copy row from db to db mysql

INSERT INTO destination_database.table_name 
  SELECT * FROM origin_database.table_name WHERE id = 1;

Posted by: Guest on February-18-2021

Code answers related to "how to copy a row into another table mysql"