获取表结构:
SELECT column_name FROM information_schema.columns WHERE table_name='表名' and CONSTRAINT_SCHEMA='数据库名';
获取Mysql 表的主键字段:
SELECT cu.Column_Name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE` cu
WHERE CONSTRAINT_NAME = 'PRIMARY' AND cu.Table_Name = '表名' AND CONSTRAINT_SCHEMA='数据库名';