03 2014 档案

摘要：FROM :http://blog.csdn.net/sunvince/article/details/7752662mysql5.1的时候新增的partition,解决了比较简单的sharding的策略mysql在已有表增加partition,mysql5.5才有,可以是innodb_file_per_table关闭状态. ##初始表CREATE TABLE IF NOT EXISTS `ccc` ( `a` int(11) NOT NULL AUTO_INCREMENT, `b` int(11) NOT NULL, PRIMARY KEY (`a`)) ENGINE=InnoDB; ... 阅读全文

摘要：FROM :http://bbs.csdn.net/topics/380025779mysql> select * from test1+------+-------+-------+| sbid | Ename | type |+------+-------+-------+| JS.1 | 甲1 | 厂家2 || JS.2 | 甲2 | 厂家1 || JS.3 | 甲3 | 厂家1 || JS.4 | 甲4 | 厂家2 || JS.5 | 乙1 | 厂家2 || HN.3 | 乙3 | 厂家1 || HN.4 | 乙8 | 厂家1 |+------+-----... 阅读全文