mysql 显示表结构命令

DESCRIBE users;

DESC users;

+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id             | int(11)     | NO   | PRI | NULL    |       |
| username       | varchar(50) | NO   |     | NULL    |       |
| email          | varchar(100)| NO   |     | NULL    |       |
| created_at     | datetime    | YES  |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+

GRANT SELECT ON your_database.users TO 'your_user'@'localhost';

DESCRIBE non_existent_table; -- 会返回错误信息

DESCRIBE `Users`; -- 如果表名是 Users（大写）