mysql - 使用另一个表值更新表

Question

有两个 MySQL 表，更新正在针对 H2 的本地测试模式下运行，并且使用 MySQL 命令行进行查询也很好。但当 Play 尝试在进化文件中使用查询时，它会失败。

Play :2.5.6斯卡拉:2.11.8

查询:

UPDATE table1 t1,table2 t2     
SET t1.user_id = t2.id
WHERE t1.buyer_id = t2.buyer_id;

错误:

[info] c.z.h.HikariDataSource - HikariCP pool db is starting.
[error] p.a.d.e.DefaultEvolutionsApi - Syntax error in SQL statement "UPDATE table1 t1,[*]table2 t2
SET t1.user_id = t2.id
WHERE t1.buyer_id = t2.buyer_id;"; expected "SET"; SQL statement:
UPDATE table1 t1,table2 t2     
SET t1.user_id = t2.id
WHERE t1.buyer_id = t2.buyer_id[42001-191] [ERROR:42001, SQLSTATE:42001]

Answer 1

update table1 join table 2 on table1.id = table2.id
set table1.name = table2.customername,
    table1.mobilenum = table2.phonenum ;