create table t1 (t int not null default 1, key (t)) engine=innodb;
885
885
desc t1;
886
Field Type Null Key Default Extra
887
t int NO MUL 1
886
Field Type Null Default Default_is_NULL On_Update
887
t INTEGER FALSE 1 FALSE
888
888
drop table t1;
889
889
create table t1 (id int not null auto_increment, code int not null, name char(20) not null, primary key (id), key (code), unique (name)) engine=innodb;
890
890
BEGIN;
1130
1130
checksum table t1, t2, t3, t4;
1131
1131
Table Checksum
1132
1132
test.t1 2948697075
1133
test.t2 2948697075
1134
test.t3 2948697075
1135
test.t4 NULL
1136
Warnings:
1137
Error 1146 Table 'test.t4' doesn't exist
1138
checksum table t1, t2, t3, t4;
1139
Table Checksum
1140
test.t1 2948697075
1141
test.t2 2948697075
1142
test.t3 2948697075
1143
test.t4 NULL
1144
Warnings:
1145
Error 1146 Table 'test.t4' doesn't exist
1146
checksum table t1, t2, t3, t4;
1147
Table Checksum
1148
test.t1 2948697075
1149
test.t2 2948697075
1150
test.t3 2948697075
1133
test.t2 3505595080
1134
test.t3 3505595080
1135
test.t4 NULL
1136
Warnings:
1137
Error 1146 Table 'test.t4' doesn't exist
1138
checksum table t1, t2, t3, t4;
1139
Table Checksum
1140
test.t1 2948697075
1141
test.t2 3505595080
1142
test.t3 3505595080
1143
test.t4 NULL
1144
Warnings:
1145
Error 1146 Table 'test.t4' doesn't exist
1146
checksum table t1, t2, t3, t4;
1147
Table Checksum
1148
test.t1 2948697075
1149
test.t2 3505595080
1150
test.t3 3505595080
1151
1151
test.t4 NULL
1152
1152
Warnings:
1153
1153
Error 1146 Table 'test.t4' doesn't exist
1428
1428
count(*)
1429
1429
1
1430
1430
drop table t1;
1431
show status like "Innodb_buffer_pool_pages_total";