求Mysql的“update……set…… from…… inner join…… on……”的正确用法

[iPaperMan]

SQL语句如下
“UPDATE batch_unlimited_history_summary SET batch_unlimited_history_summary.upd_date = NOW(),
batch_unlimited_history_summary.upd_user = 'B170',
batch_unlimited_history_summary.regist_store_type = regist.regist_store_type FROM batch_unlimited_history_summary AS summary INNER JOIN batch_unlimited_history_regist AS regist ON summary.user_id = regist.user_id
AND summary.regist_date = regist.regist_date”
执行后报语法错误
“[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM batch_unlimited_history_summary AS summary
INNER JOIN batch_unlimited_hi' at line 3”
应该怎样修改，求大神帮忙……

[iPaperMan]

写法错了，正确的写法应该是：

UPDATE batch_unlimited_history_summary AS summary 
 INNER JOIN batch_unlimited_history_regist AS regist 
ON summary.user_id = regist.user_id
 AND summary.regist_date = regist.regist_date
SET summary.upd_date = NOW(),
 summary.upd_user = 'B170',
 summary.regist_store_type = regist.regist_store_type 

[LongRui888]

引用 1 楼 PapperMan 的回复:

写法错了，正确的写法应该是：

UPDATE batch_unlimited_history_summary AS summary 
 INNER JOIN batch_unlimited_history_regist AS regist 
ON summary.user_id = regist.user_id
 AND summary.regist_date = regist.regist_date
SET summary.upd_date = NOW(),
 summary.upd_user = 'B170',
 summary.regist_store_type = regist.regist_store_type 

学习了