mysql 查询数据库表结构

1. 

mysql> describe tmp_log;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| id       | int(20) unsigned | NO   | PRI | NULL    | auto_increment |
| url      | varchar(200)     | YES  |     |         |                |
| userName | varchar(200)     | YES  |     |         |                |
+----------+------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

2

mysql> describe tmp_log G;
*************************** 1. row ***************************
  Field: id
   Type: int(20) unsigned
   Null: NO
    Key: PRI
Default: NULL
  Extra: auto_increment
*************************** 2. row ***************************
  Field: url
   Type: varchar(200)
   Null: YES
    Key: 
Default: 
  Extra: 
*************************** 3. row ***************************
  Field: userName
   Type: varchar(200)
   Null: YES
    Key: 
Default: 
  Extra: 
3 rows in set (0.00 sec)

ERROR: 
No query specified

3

mysql> desc tmp_log;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| id       | int(20) unsigned | NO   | PRI | NULL    | auto_increment |
| url      | varchar(200)     | YES  |     |         |                |
| userName | varchar(200)     | YES  |     |         |                |
+----------+------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

4

mysql> show  columns from tmp_log;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| id       | int(20) unsigned | NO   | PRI | NULL    | auto_increment |
| url      | varchar(200)     | YES  |     |         |                |
| userName | varchar(200)     | YES  |     |         |                |
+----------+------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

5

mysql> show create table tmp_log;
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                                                                                                                                     |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tmp_log | CREATE TABLE `tmp_log` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT '' COMMENT '链接',
  `userName` varchar(200) DEFAULT '' COMMENT '用户名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8      |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)