drop table if exists shops;
create table shops (
id int primary key auto_increment,
name text,
location geometry NOT NULL,
spatial key location_index (location)
) comment = 'engine "innodb"';
show create table shops;
Table	Create Table
shops	CREATE TABLE `shops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `location` geometry NOT NULL,
  PRIMARY KEY (`id`),
  SPATIAL KEY `location_index` (`location`)
) ENGINE=Mroonga DEFAULT CHARSET=latin1 COMMENT='engine "innodb"'
insert into shops (name, location)
values ('sazare',
GeomFromText('POINT(139.685043 35.714653)'));
select id, name, AsText(location) as location_text from shops
where MBRContains(GeomFromText('LineString(139.68466 35.71592, 139.68804 35.71411)'), location);
id	name	location_text
1	sazare	POINT(139.685043 35.714653)
delete from shops
where MBRContains(GeomFromText('LineString(139.68466 35.71592, 139.68804 35.71411)'), location);
select id, name, AsText(location) as location_text from shops
where MBRContains(GeomFromText('LineString(139.68466 35.71592, 139.68804 35.71411)'), location);
id	name	location_text
select id, name, AsText(location) as location_text from shops;
id	name	location_text
drop table shops;