MySQL資料庫delete資料時,不支援表別名

ZHOU_VIP發表於2019-01-07

第一條語句會報錯:

錯誤碼: 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 't where t.deveui = ''' at line 1

第二條語句則可以,原來是mysql資料庫delete資料時,不支援表別名。

https://blog.csdn.net/huangxingchen123/article/details/52608408

相關文章