一、查看当前数据库下的数据表
格式：
show tables;
示例：
mysql> show tables;
----------------
| Tables_in_test |
----------------
| article |
| article_cate |
----------------
4 rows in set (0.00 sec)
二、查看表结构和编码以及引擎
格式：
show create table 表名称;
示例：
mysql> show create table article;
--------- ---------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------
| Table | Create Table
|
--------- ---------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------
| article | CREATE TABLE `article` (
`id` int(10) unsigned NOT NULL auto_increment,
`author` varchar(40) NOT NULL,
`title` varchar(250) NOT NULL,
`datetime` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 |
--------- ---------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------
1 row in set (0.00 sec)
三、查看表字段
格式：
desc 表名称;
示例：
mysql> desc article;
---------- ------------------ ------ ----- --------- ----------------
| Field | Type | Null | Key | Default | Extra |
---------- ------------------ ------ ----- --------- ----------------
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| author | varchar(40) | NO | | NULL | |
| title | varchar(250) | NO | | NULL | |
| datetime | date | YES | | NULL | |
---------- ------------------ ------ ----- --------- ----------------
4 rows in set (0.00 sec)
格式：
describe 表名称;
示例：
mysql> describe article;
---------- ------------------ ------ ----- --------- ----------------
| Field | Type | Null | Key | Default | Extra |
---------- ------------------ ------ ----- --------- ----------------
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| author | varchar(40) | NO | | NULL | |
| title | varchar(250) | NO | | NULL | |
| datetime | date | YES | | NULL | |
---------- ------------------ ------ ----- --------- ----------------
4 rows in set (0.02 sec)
格式：
show columns from 表名称;
示例：
mysql> show columns from article;
---------- ------------------ ------ ----- --------- ----------------
| Field | Type | Null | Key | Default | Extra |
---------- ------------------ ------ ----- --------- ----------------
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| author | varchar(40) | NO | | NULL | |
| title | varchar(250) | NO | | NULL | |
| datetime | date | YES | | NULL | |
---------- ------------------ ------ ----- --------- ----------------
4 rows in set (0.00 sec)