给mysql字段增加描述信息_mysql 添加字段及给字段添加属性

mysql> desc customers;

//表结构

+-----------+-----------------+------+-----+---------+----------------+|

Field

|

Type

| Null | Key | Default |

Extra

|+-----------+-----------------+------+-----+---------+----------------+|

c_id

|

int(11)

| NO   | PRI |

NULL    |

auto_increment ||

c_name    |

char(50)

| NO

|

| NULL

|

|| c_address |

char(50)

| YES

|

| NULL

|

|| c_city    |

char(50)

| YES

|

| NULL

|

||

c_zip

|

char(10)

| YES

|

| NULL

|

|| c_contact |

char(50)

| YES

|

| NULL

|

|| c_ema