CREATE TABLE `t` (
`tid` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(10) DEFAULT NULL,
`sdate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
mysql> insert into t(tid) values(1);
ERROR 1064 (HY000): bad insert sql (sharding column:ID not provided,INSERT INTO t (tid) VALUES (1)
-- schema.xml 中表t的配置
<table name='t' type="global" dataNode="dn4,dn1" rule="mod-long"/>
type="global" 表明t是全局表,全局表是不需要配置分片规则的。把rule="mod-long"去掉,重启mycat,ok。
`tid` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(10) DEFAULT NULL,
`sdate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
mysql> insert into t(tid) values(1);
ERROR 1064 (HY000): bad insert sql (sharding column:ID not provided,INSERT INTO t (tid) VALUES (1)
-- schema.xml 中表t的配置
<table name='t' type="global" dataNode="dn4,dn1" rule="mod-long"/>
type="global" 表明t是全局表,全局表是不需要配置分片规则的。把rule="mod-long"去掉,重启mycat,ok。