查看
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)