mysql 查询表存在 mysql数据库如何快速获得库中无主键的表 – 数据库 – 前端 ssh 登陆 mysql

SELECT

table_schema,

table_name

FROM

information_schema. TABLES

WHERE

(table_schema, table_name) NOT IN (

SELECT DISTINCT

table_schema, table_name

FROM

information_schema. COLUMNS

WHERE

COLUMN_KEY = ‘PRI’

)

AND table_schema NOT IN (

‘sys’,

‘mysql’,

‘information_schema’,

‘performance_schema’

);