17 lines
454 B
Plaintext
17 lines
454 B
Plaintext
DROP TABLE IF EXISTS t1;
|
|
create table t1(
|
|
id bigint not null primary key,
|
|
i1 bigint, #unique
|
|
i2 bigint, #repeating
|
|
c1 varchar(20), #unique
|
|
c2 varchar(20), #repeating
|
|
index t1_2(i1)
|
|
) engine=xengine;
|
|
select count(*), sum(id), sum(i1), sum(i2) from t1;
|
|
count(*) sum(id) sum(i1) sum(i2)
|
|
20000 200010000 200010000 19992000
|
|
select count(*), sum(id), sum(i1), sum(i2) from t1;
|
|
count(*) sum(id) sum(i1) sum(i2)
|
|
20000 200010000 200010000 19992000
|
|
drop table t1;
|