drop table if exists listing;
set names utf8;
create table scores (
name char(30) not null,
score int not null,
primary key (name, score)
) default charset utf8;
show create table scores;
Table	Create Table
scores	CREATE TABLE `scores` (
  `name` char(30) NOT NULL,
  `score` int(11) NOT NULL,
  PRIMARY KEY (`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;
name	score
Jiro Yamada	27
Taro Yamada	-12
Taro Yamada	10
Taro Yamada	29
delete from scores where name = "Taro Yamada" and score = 10;
select * from scores where name = "Taro Yamada" and (score >= -12 and score < 29);
name	score
Taro Yamada	-12
drop table scores;
