[thelist] Copy Data in MySQL

r937 rudy at r937.com
Thu May 12 04:25:55 CDT 2011


> I guess I have to do it in PHP, eh?

nope   ;o)


UPDATE tableA
INNER
  JOIN tableB
    ON tableB.fk = tableA.fk
   SET tableB.datafield = tableA.datafield


--
rudy
http://r937.com/




More information about the thelist mailing list