Travelrecord精品文章

• 

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

  ...創(chuàng)建了3個(gè)分庫，每個(gè)分庫下每一個(gè)對應(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 評論0 收藏0
• 

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

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

  el09xccxy 2019-06-25 18:59 評論0 收藏0
• 

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

  ... CHARSET utf8mb4 COLLATE utf8mb4_general_ci; # 三個(gè)分庫各自創(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 評論0 收藏0