之前写了个delete语句因为包含了子查询 ,一直执行不成功
DELETE FROM m_merchant_platform_user t where t.id_card in (select ut.id_number from u_platform_user ut where ut.id=111)
后面查资料发现delete如果包含子查询 不能带别名,改成如下:
DELETE FROM m_merchant_platform_user where id_card in (select ut.id_number from u_platform_user ut where ut.id=111)
执行成功~