[thelist] Copy Data in MySQL

Fred Jones fredthejonester at gmail.com
Tue May 10 12:35:37 CDT 2011


I have 2 tables in a MySQL DB. Each has three fields (which are relevant):

id
fk
datafield

id is the autoincrement primary key.
fk is a foreign key to another table (both fk's reference the same third table)
datafield is some data

What I want to do is copy datafield from table A to table B, per the
fk field. To be clear, once it's done the value of datafield in A will
match that in B for fk value 1, and again for value 2, 3 etc.

I'm not sure how to do this however...

Fred


More information about the thelist mailing list