# drop old table, and delete old data record
drop table if exists db_not_tb__city;
delete from mycat_sequence where name = 'sharding_db_not_tb__city';
# create sequence.json
# 故意创建一个矛盾的由 MySQL 生辰的序列
# 其实没必要，使用 MySQL 生成序列时，感觉 Mycat 不会创建、维护全局序列，需要数据库设计者自行设计。
insert into mycat_sequence values('sharding_db_not_tb__city',0,1);
/*+ mycat:setSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */;
# 会报错，不支持
# drop sequence sharding_db_not_tb111;
/*+ mycat:setSequence{"name":"sharding_db_not_tb__city","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */;
/*+ mycat:dropSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */;
# create table and insert data
/*+ mycat:createTable{
"schemaName":"sharding",# drop old table, and delete old data record
drop table if exists db_not_tb__city;
delete from mycat_sequence where name = 'sharding_db_not_tb__city';
# create sequence.json
# 故意创建一个矛盾的由 MySQL 生辰的序列
# 其实没必要，使用 MySQL 生成序列时，感觉 Mycat 不会创建、维护全局序列，需要数据库设计者自行设计。
insert into mycat_sequence values('sharding_db_not_tb__city',0,1);
/*+ mycat:setSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */;
# 会报错，不支持
# drop sequence sharding_db_not_tb111;
/*+ mycat:setSequence{"name":"sharding_db_not_tb__city","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */;
/*+ mycat:dropSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */;
# create table and insert data
/*+ mycat:createTable{
"schemaName":"sharding",
"shardingTable":{
"createTableSQL":"create table db_not_tb__city(id int auto_increment primary key,name varchar(10),city varchar(10)) dbpartition by MOD_HASH(city) dbpartitions 2",
"function":{
"properties":{
"dbNum":2,
"dbMethod":"mod_hash(city)",
"mappingFormat":"cls${targetIndex}/sharding/db_not_tb__city",
"storeNum":2
}
}
},
"tableName":"db_not_tb__city"
} */;
insert into db_not_tb__city(name,city) values('a','sh'),('b','sh'),('c','bj'),('d','sh'),('e','sz'),('f','bj'),('g','bj'),('h','sz');
# check data
select t.*,@@hostname from db_not_tb__city t order by id;
