delete from exam_paper_question_opt a WHERE a.OPTION_ID = 65630 and a.QUESTION_ID = 28656 AND a.EXAM_PAPER_ID = 1533
[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 'a WHERE a.OPTION_ID = 65630 and a.QUESTION_ID = 28656 AND a.EXAM_PAPER_ID = 1533' at line 1
今天删除数据的时候报错了,仔细看sql发现没有任何问题,然后就把表的别名删了,结果就成功了,原来mysqldelete的时候,表是无法使用别名的,谨以此记录