SELECT table_name, column_name FROM information_schema.`COLUMNS` WHERE table_schema = 'xxxdb' AND FIND_IN_SET(table_name, 'xxx_proj,xxx_proj_history') GROUP BY column_name HAVING COUNT(1) = 1 ;
本文共 247 字，大约阅读时间需要 1 分钟。
SELECT table_name, column_name FROM information_schema.`COLUMNS` WHERE table_schema = 'xxxdb' AND FIND_IN_SET(table_name, 'xxx_proj,xxx_proj_history') GROUP BY column_name HAVING COUNT(1) = 1 ;
转载于:https://my.oschina.net/u/246522/blog/179502