mysql> ALTER TABLE `top_product` CHANGE `halfsrchs` `halfsrchs` BIGINT( 11 ) NOT NULL DEFAULT '0', CHANGE `yearsrchs` `yearsrchs` BIGINT( 11 ) NOT NULL DEFAULT '0';
Query OK, 2982201 rows affected (8.38 sec)
1G 大概50s
-rw-rw---- 1 mysql mysql 9.0K Nov 23 17:23 top_product.frm
-rw-rw---- 1 mysql mysql 185M Nov 23 17:23 top_product.MYD
-rw-rw---- 1 mysql mysql 49M Nov 23 17:23 top_product.MYI
阅读(2387) | 评论(1) | 转发(0) |
