1
DROP TABLE IF EXISTS `sbtest`;
3
Note 1051 Unknown table 'sbtest'
4
CREATE TABLE `sbtest` (
5
`id` INT NOT NULL AUTO_INCREMENT,
6
`k` INT NOT NULL DEFAULT '0',
7
`o` INT NOT NULL DEFAULT '0',
8
`c` VARCHAR(120) NOT NULL COLLATE utf8_general_ci,
9
`pad` VARCHAR(60) NOT NULL COLLATE utf8_general_ci,
13
) ENGINE='InnoDB' AUTO_INCREMENT=1 COLLATE='utf8_general_ci';
14
ALTER TABLE `sbtest` DISABLE KEYS;
16
Note 1031 Table storage engine for 'sbtest' doesn't have this option
18
ALTER TABLE `sbtest` ENABLE KEYS;
20
Note 1031 Table storage engine for 'sbtest' doesn't have this option
21
select * from sbtest where k=5003;
23
5003 5003 5003 qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt