189
189
CREATE TABLE `test`.`t1` ( `a` ENUM('a','bb','ccc') NOT NULL, `b` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL, `c` INT DEFAULT NULL, `d` INT DEFAULT NULL, PRIMARY KEY (`a`), UNIQUE KEY `b` (`b`), UNIQUE KEY `c` (`c`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
191
191
START TRANSACTION;
192
INSERT INTO `test`.`t1` (`a`,`b`,`c`,`d`) VALUES (a,'a',1,1);
193
INSERT INTO `test`.`t1` (`a`,`b`,`c`,`d`) VALUES (bb,'b',2,2);
194
INSERT INTO `test`.`t1` (`a`,`b`,`c`,`d`) VALUES (ccc,'c',3,3);
192
INSERT INTO `test`.`t1` (`a`,`b`,`c`,`d`) VALUES ('a','a',1,1);
193
INSERT INTO `test`.`t1` (`a`,`b`,`c`,`d`) VALUES ('bb','b',2,2);
194
INSERT INTO `test`.`t1` (`a`,`b`,`c`,`d`) VALUES ('ccc','c',3,3);
196
196
START TRANSACTION;
197
DELETE FROM `test`.`t1` WHERE `a`=a;
198
DELETE FROM `test`.`t1` WHERE `a`=bb;
199
UPDATE `test`.`t1` SET `a`=a,`b`='b',`d`=4 WHERE `a`=ccc;
197
DELETE FROM `test`.`t1` WHERE `a`='a';
198
DELETE FROM `test`.`t1` WHERE `a`='bb';
199
UPDATE `test`.`t1` SET `a`='a',`b`='b',`d`=4 WHERE `a`='ccc';
201
201
START TRANSACTION;
202
202
DROP TABLE `test`.`t1`;