MySQL查自增表及主键字段

最新推荐文章于 2024-04-09 09:28:12 发布

qiu_cs

最新推荐文章于 2024-04-09 09:28:12 发布

阅读量201

点赞数 3

文章标签： mysql 数据库 sql

本文链接：https://blog.csdn.net/qiu_cs/article/details/137518679

版权

查询SQL

select 
 t.table_name,  t.column_name
from 
(SELECT k.table_name, lower( k.column_name) AS column_name
FROM information_schema.table_constraints t
JOIN information_schema.key_column_usage k
USING(constraint_name,table_schema,table_name)
WHERE t.constraint_type='PRIMARY KEY'
  AND t.table_schema='test' ) t
  join information_schema.TABLES a on a. TABLE_SCHEMA = 'test' and a.table_name=t.table_name AND a.AUTO_INCREMENT IS NOT NULL