获取数据库中除系统库之外所有无主键的表sql如下:
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’
);
mysql 如何进入,mysql限制并发写入,mysql 无法被外网访问,mysql存图片存储路径,新增mysql用户,mysql启动的两种方式