An easy single command to copy a record from one table to another in MySQL:

   insert into destinationdb.destinationtable
     select * from sourcedatabase.sourcetable
     where code = ‘123’;