随笔分类 - 测试验证

mysql中更改字段属性实际上都做了哪些操作

摘要：mysql> set profiling=1;Query OK, 0 rows affected (0.00 sec)mysql> alter table test modify name varchar(10);Query OK, 3 rows affected (0.00 sec)Records... 阅读全文

posted @ 2014-09-07 09:38 zitong 阅读(230) 评论(0) 推荐(0)

超过varchar定义长度

摘要：mysql> select version();+------------+| version() |+------------+| 5.1.73-log |+------------+1 row in set (0.00 sec)mysql> show variables like 'colla... 阅读全文

posted @ 2014-09-07 09:33 zitong 阅读(566) 评论(0) 推荐(0)