日期:2014-05-16 浏览次数:20929 次
mysql> desc info ; +---------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+------------------+------+-----+---------+-------+ | id | int(10) unsigned | NO | PRI | 0 | | | name | text | YES | | NULL | | +---------+------------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
mysql> desc tend \G *************************** 1. row *************************** Field: id Type: int(10) unsigned Null: NO Key: PRI Default: NULL Extra: auto_increment *************************** 2. row *************************** Field: u1 Type: varchar(150) Null: YES Key: Default: NULL Extra: *************************** 3. row *************************** Field: u2 Type: varchar(150) Null: YES Key: Default: NULL Extra: *************************** 4. row *************************** Field: u3 Type: varchar(150) Null: YES Key: Default: NULL Extra: *************************** 5. row *************************** Field: u4 Type: varchar(150) Null: YES Key: Default: NULL Extra: *************************** 6. row *************************** Field: u5 Type: varchar(150) Null: YES Key: Default: NULL Extra: 6 rows in set (0.00 sec) mysql>