Saturday, March 13, 2010

Creating spatial database in MySQL

CREATE TABLE `dev_atacan_rets`.`points` (
`name` VARCHAR(20) NOT NULL,
`location` POINT NOT NULL,
`description` VARCHAR(200),
SPATIAL INDEX(location)
)
ENGINE = MyISAM;

(Engine part is the important part)

No comments:

Post a Comment