语法错误“near FROM"在 MySQL 中使用 UPDATE 和 JOIN 时? [英] Syntax error "near FROM" when using UPDATE with JOIN in MySQL?

问题描述

UPDATE bestall SET view = t1.v, rawview = t1.rv 

FROM bestall INNER JOIN beststat as t1

ON bestall.bestid = t1.bestid

此查询在附近出现语法错误

this query gives syntax error near

 'FROM bestall INNER JOIN beststat as t1 ON bestall.bestid = t1.bestid' at line 3

有什么原因吗?

推荐答案

这不是有效的 MySQL 语法.但是，它在 MS SQL Server 中有效.对于 MySQL，请使用:

That isn't valid MySQL syntax. It is valid in MS SQL Server, however. For MySQL, use:

UPDATE 
  bestall
  JOIN beststat AS t1 ON bestall.bestid = t1.bestid 
SET view = t1.v, rawview = t1.rv

MySQL 要求更新表位于 SET 子句之前.请参阅MySQL UPDATE 语法参考了解完整详情.

MySQL requires the update tables to come before the SET clause. See the MySQL UPDATE syntax reference for full details.

这篇关于语法错误“near FROM"在 MySQL 中使用 UPDATE 和 JOIN 时?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！