Installation issues faced by me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment