copy in mysql

August 21, 2012 MySQL no responses # ,

Copy one field to another in MySQL

Rule is simple:

udpate table_name set  destination_column=source_column

If you want to update multiple tables and you can join on that table you can use the join syntax also in the UPDATE:

Continue reading

Pin It on Pinterest