mysql 命令行查看表

-- 进入MySQL命令行
mysql> USE database_name;

-- 查看当前数据库中的所有表
mysql> SHOW TABLES;
+----------------+
| Tables_in_database_name |
+----------------+
| users           |
+----------------+

-- 查看表的详细信息
mysql> DESCRIBE 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    |       |
+-----------------+-------------+------+-----+---------+-------+