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’; Share:EmailFacebookTwitterPinterestReddit Related Post navigation Previous PostNext Post