关于MySQL Update 别名的问题

[CENACLE]

[SQL] EXPLAIN UPDATE a
SET nn = '1'
FROM
t1 a

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM
t1 a' at line 3


我一直用的MSSQL，请Mysql的大神指导一下！

[CENACLE]

忘了说了，引擎是InnoDB

[SWAT特训营]

update里面不能出现from,mysql语法和sqlserve还是有少许不一样的地方 UPDATE t1 a SET nn = '1'

[李木子QQ]

UPDATE 表名 SET nn = '1'

[rucypli]

EXPLAIN UPDATE a SET nn = '1'

[Deman丶T]

update well 事实

[ZXYperseverance]

语法错误 update 后面跟表名。 你可以查询下update 的用法。