DELETE FROM or_cyreplenish_assign_item_bak_et t WHERE date_format(t.CREATE_TIME, '%Y%m%d%H') = '2020070201' AND t.CREATE_USER = 'SYSTEM';
会报错
DELETE FROM or_cyreplenish_assign_item_bak_et t WHERE date_format(t.CREATE_TIME, '%Y%m%d%H') = '2020070201' AND t.CREATE_USER = 'SYSTEM';
[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 't WHERE date_format(t.CREATE_TIME, '%Y%m%d%H') = '2020070201' AND t.CREATE_USER ' at line 2
把别名去掉,就好了:
DELETE FROM or_cyreplenish_assign_item_bak_et WHERE date_format(t.CREATE_TIME, '%Y%m%d%H') = '2020070201' AND CREATE_USER = 'SYSTEM';