Copy a record in MySQL

Beergeek | October 29, 2002

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′;

Categories
Grumpy Computer Geek

« Spam goes to a trickle. Skyline online prices sky high - updated »