EVOLUTION-MANAGER

Edit File: index_multiple_column_update_int.result

DROP TABLE IF EXISTS scores; CREATE TABLE scores ( id INT PRIMARY KEY AUTO_INCREMENT NOT NULL, name CHAR(30) NOT NULL, score INT NOT NULL, KEY property (score, name) ) DEFAULT CHARSET=UTF8; SHOW CREATE TABLE scores; Table Create Table scores CREATE TABLE `scores` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` char(30) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `property` (`score`,`name`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 INSERT INTO scores (name, score) VALUES("Taro Yamada", 29); INSERT INTO scores (name, score) VALUES("Taro Yamada", -12); INSERT INTO scores (name, score) VALUES("Jiro Yamada", 29); INSERT INTO scores (name, score) VALUES("Taro Yamada", 10); SELECT * FROM scores WHERE score = 29; id name score 3 Jiro Yamada 29 1 Taro Yamada 29 UPDATE scores SET name = "Saburo YAMADA" WHERE id = 3; SELECT * FROM scores WHERE score = 29; id name score 3 Saburo YAMADA 29 1 Taro Yamada 29 DROP TABLE scores;