Travelrecord精品文章

• 

  Mycat的實(shí)踐二：全局序列號(hào)

  ...創(chuàng)建了3個(gè)分庫(kù)，每個(gè)分庫(kù)下每一個(gè)對(duì)應(yīng)的表 CREATE TABLE `travelrecord` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(22) NOT NULL DEFAULT , `time` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY K...

  DesGemini 2019-07-01 10:25 評(píng)論0 收藏0
• 

  基于代理的數(shù)據(jù)庫(kù)分庫(kù)分表框架 Mycat實(shí)踐

  ...l -utest -ptest -h127.0.0.1 -P8066 -DTESTDB 通過(guò) MyCAT來(lái)創(chuàng)建數(shù)據(jù)庫(kù) travelrecord create table travelrecord (id bigint not null primary key,city varchar(100),create_date DATE); 通過(guò) MyCAT來(lái)往travelrecord表中插入兩條數(shù)...

  el09xccxy 2019-06-25 18:59 評(píng)論0 收藏0
• 

  Mycat的實(shí)踐一：初始Mycat

  ... CHARSET utf8mb4 COLLATE utf8mb4_general_ci; # 三個(gè)分庫(kù)各自創(chuàng)建表travelrecord CREATE TABLE `travelrecord` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(22) NOT NULL DEFAULT , `time`...

  Paul_King 2019-07-01 10:25 評(píng)論0 收藏0