mysql如何获取主键

SHOW CREATE TABLE table_name;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DESCRIBE table_name;

DESC table_name;

+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(255)| NO   |     | NULL    |                |
| email | varchar(255)| NO   |     | NULL    |                |
+-------+------------->

SELECT COLUMN_NAME
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'database_name'
AND TABLE_NAME = 'table_name'
AND COLUMN_KEY = 'PRI';

+-------------+
| COLUMN_NAME |
+-------------+
| id          |
+-------------+

-- 使用SHOW CREATE TABLE语句
SHOW CREATE TABLE users;

-- 使用DESCRIBE语句
DESCRIBE users;

-- 使用information_schema数据库
SELECT COLUMN_NAME
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'your_database_name'
AND TABLE_NAME = 'users'
AND COLUMN_KEY = 'PRI';