1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS t1;
create table t1
(c01 bigint unsigned not null auto_increment primary key,
c02 bigint unsigned not null default 0,
c03 bigint unsigned not null default 0,
c04 bigint unsigned not null default 0,
c05 bigint unsigned not null default 0,
c06 bigint unsigned not null default 0,
c07 bigint unsigned not null default 0,
c08 bigint unsigned not null default 0,
c09 bigint unsigned not null default 0,
c10 bigint unsigned not null default 0)
engine=tokudb;
insert into t1 (c01) values (NULL);
insert into t1 (c02,c03,c04,c05,c06,c07,c08,c09,c10) select c02,c03,c04,c05,c06,c07,c08,c09,c10 from t1;
flush tables;
select * from t1;
c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
1 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0
DROP TABLE t1;
|
