EVOLUTION-MANAGER

Edit File: index_multiple_column_delete.result

drop table if exists listing; set names utf8; create table scores ( id int primary key auto_increment not null, name char(30) not null, score int not null, index property (name, score) ) 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` (`name`,`score`) ) 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", 27); insert into scores (name, score) values("Taro Yamada", 10); select * from scores; id name score 1 Taro Yamada 29 2 Taro Yamada -12 3 Jiro Yamada 27 4 Taro Yamada 10 delete from scores where name = "Taro Yamada" and score = 10; select * from scores where name = "Taro Yamada" and (score >= -12 and score < 29); id name score 2 Taro Yamada -12 drop table scores;