修改表结构中的一个值

查看

mysql> desc  ts_weiba_post ;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| post_id         | int(11)      | NO   | PRI | NULL    | auto_increment |
| weiba_id        | int(11)      | NO   |     | NULL    |                |
| post_uid        | int(11)      | NO   |     | NULL    |                |
| title           | varchar(255) | NO   |     | NULL    |                |
| content         | text         | NO   |     | NULL    |                |
| post_time       | int(11)      | NO   | MUL | NULL    |                |
| reply_count     | int(10)      | YES  |     | 0       |                |
| read_count      | int(10)      | YES  |     | 0       |                |
| last_reply_uid  | int(11)      | YES  |     | 0       |                |
| last_reply_time | int(11)      | YES  |     | 0       |                |
| digest          | tinyint(1)   | YES  |     | 0       |                |
| top             | tinyint(1)   | YES  |     | 0       |                |
| lock            | tinyint(1)   | YES  |     | 0       |                |
| recommend       | tinyint(1)   | YES  |     | 0       |                |
| recommend_time  | int(11)      | YES  | MUL | 0       |                |
| is_del          | tinyint(2)   | YES  |     | 0       |                |
| feed_id         | int(11)      | NO   |     | NULL    |                |
| reply_all_count | int(11)      | NO   |     | 0       |                |
| attach          | varchar(255) | YES  |     | NULL    |                |
| praise          | int(11)      | YES  |     | 0       |                |
| from            | tinyint(2)   | YES  |     | 0       |                |
| top_time        | int(11)      | YES  |     | NULL    |                |
| is_index        | tinyint(2)   | YES  |     | 0       |                |
| index_img       | int(11)      | YES  |     | NULL    |                |
| is_index_time   | int(11)      | YES  |     | NULL    |                |
| city            | int(11)      | YES  |     | NULL    |                |
| img_ids         | varchar(255) | YES  |     | NULL    |                |
| tag_id          | int(11)      | YES  |     | NULL    |                |
| index_order     | int(11)      | YES  |     | 0       |                |
| is_event        | tinyint(1)   | YES  |     | 0       |                |
+-----------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)

修改

mysql> alter table ts_weiba_post change   text content mediumtext;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

修改完成测试

mysql> desc  ts_weiba_post ;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| post_id         | int(11)      | NO   | PRI | NULL    | auto_increment |
| weiba_id        | int(11)      | NO   |     | NULL    |                |
| post_uid        | int(11)      | NO   |     | NULL    |                |
| title           | varchar(255) | NO   |     | NULL    |                |
| content         | mediumtext   | YES  |     | NULL    |                |
| post_time       | int(11)      | NO   | MUL | NULL    |                |
| reply_count     | int(10)      | YES  |     | 0       |                |
| read_count      | int(10)      | YES  |     | 0       |                |
| last_reply_uid  | int(11)      | YES  |     | 0       |                |
| last_reply_time | int(11)      | YES  |     | 0       |                |
| digest          | tinyint(1)   | YES  |     | 0       |                |
| top             | tinyint(1)   | YES  |     | 0       |                |
| lock            | tinyint(1)   | YES  |     | 0       |                |
| recommend       | tinyint(1)   | YES  |     | 0       |                |
| recommend_time  | int(11)      | YES  | MUL | 0       |                |
| is_del          | tinyint(2)   | YES  |     | 0       |                |
| feed_id         | int(11)      | NO   |     | NULL    |                |
| reply_all_count | int(11)      | NO   |     | 0       |                |
| attach          | varchar(255) | YES  |     | NULL    |                |
| praise          | int(11)      | YES  |     | 0       |                |
| from            | tinyint(2)   | YES  |     | 0       |                |
| top_time        | int(11)      | YES  |     | NULL    |                |
| is_index        | tinyint(2)   | YES  |     | 0       |                |
| index_img       | int(11)      | YES  |     | NULL    |                |
| is_index_time   | int(11)      | YES  |     | NULL    |                |
| city            | int(11)      | YES  |     | NULL    |                |
| img_ids         | varchar(255) | YES  |     | NULL    |                |
| tag_id          | int(11)      | YES  |     | NULL    |                |
| index_order     | int(11)      | YES  |     | 0       |                |
| is_event        | tinyint(1)   | YES  |     | 0       |                |
+-----------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)