MySQL 获取表的主键和表结构

-- 获取所有表或指定表的主键

SELECT
	k.column_name,
	t.table_name,
	table_schema 
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 = DATABASE () 
	AND t.table_name = 'sys_menu';

-- 	获取表结构
SELECT
	table_schema,
	table_name,
	column_name,
	column_type,
	column_key,
	is_nullable,
	column_default,
	column_comment,
	character_set_name 
FROM
	information_schema.COLUMNS 
WHERE
	table_schema = DATABASE () 
	AND table_name = 'qrtz_blob_triggers';