9
9
ON DUPLICATE KEY UPDATE padding="I love testing";
12
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
12
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
15
15
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');