2010-12-15 UPDATE MYSQL UPDATE tableA, tableB SET tableA.dousa_group_id = tableB.group_id WHERE tableA.dousa_id = tableB.ID