10
10
ALTER TABLE t1 ADD INDEX ix_padding (padding(20));
13
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
13
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
16
16
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');