SELECT
table_name,
column_name
FROM
information_schema.COLUMNS
WHERE
table_schema = 'database1'
AND table_name NOT IN ( SELECT table_name FROM information_schema.COLUMNS WHERE table_schema = 'database1' AND column_name = 'sss_id' GROUP BY table_name )
AND table_name NOT LIKE 'ppp_%'
AND table_name NOT LIKE 'aaa_%'
AND table_name NOT LIKE 'bbb_%'
AND table_name NOT LIKE 'ccc_%'
GROUP BY
table_name;
查询不包含sss_id的表