文章来源:http://www.iteye.com/problems/99260什么是数据表的复合主键 所谓的复合主键 就是指你表的主键含有一个以上的字段组成 比如 create table test ( name varchar(19), id number, value varchar(10), prim...【阅读全文】
我们用status或者mysqladmin -V查看mysql版本,如果需要查看编译参数那么就要用到mysqlbug了.下面演示一下演示版本:mysql5.6.15[mysql@localhost ~]$ mysqlbug Finding system information for a MySQL bug reporttest -x Could not find a text editor. (tried emacs)You can change editor by setting t...【阅读全文】
初始表CREATE TABLE IF NOT EXISTS `time` ( `a` int(11) NOT NULL AUTO_INCREMENT, `b` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; 更改表为partitionALTER TABLE timePARTITION BY RANGE(id)(PARTITION p0 VALUES LESS THAN (3),PARTITION p1 VALUES LESS THAN (4));&nb...【阅读全文】