阅读背景:

条件相同但错误导致mysql删除并选择

来源:互联网 
DELETE
FROM TB_VALIDATE_PARAM
WHERE UPPER(CONCAT(c_object_id, c_column_code)) NOT IN (
    SELECT UPPER(CONCAT(COL.TABLE_NAME, COL.COLUMN_NAME))
    FROM information_schema.COLUMNS AS COL
    WHERE COL.TABLE_SCHEMA = 'jlink'
);

SELECT * 
FROM TB_VALIDATE_PARAM
WHERE UPPER(CONCAT(c_object_id, c_column_code)) NOT IN (
    SELECT UPPER(CONCAT(COL.TABLE_NAME, COL.COLUMN_NAME))
    FROM information_schema.COLUMNS AS COL
    WHERE COL.TABLE_SCHEMA = 'jlink'
);
DELETE
FROM TB_VALIDATE_PARAM
WHERE UPPER(CONCA



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: