查询表是否有主键
SELECT
t.table_schema, t.table_name
FROM
information_schema.TABLES AS t
LEFT JOIN
information_schema.TABLE_CONSTRAINTS AS c ON t.TABLE_SCHEMA = c.TABLE_SCHEMA
AND t.TABLE_NAME = c.TABLE_NAME
AND c.CONSTRAINT_TYPE = 'PRIMARY KEY'
WHERE
c.CONSTRAINT_TYPE IS NULL
AND t.TABLE_TYPE = 'BASE TABLE'
AND t.TABLE_SCHEMA NOT IN ('mysql' , 'information_schema',
'performance_schema',
'sys');