mysql ：you can't specify target table 'crm_tmk_relationship' for update in FROM clause

其实翻译过来就是：不能先select出同一表中的某些值，再update这个表(在同一语句中)

其实很简单的处理方法，在查询外面再包一层即可

DELETE FROM crm_tmk_relationship WHERE ID IN (
SELECT * FROM(
SELECT ID from crm_tmk_relationship WHERE CREATE_DATE > '2019-07-08 10:10:00' AND CREATE_USER = 'chuaihongli') AS c
) ;