delete报错整理

delete报错整理

delete from order_express oe where TO_DAYS(NOW()) - TO_DAYS(oe.create_time) = 1 ;

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 'oe where TO_DAYS(NOW()) - TO_DAYS(oe.create_time) = 1' at line 7

delete from table :这里的table表名不能用别名。