创建实验index1表-mysql地理搜索

create_index1.mysql

CREATE TABLE `index1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lat` DECIMAL(9, 6) NOT NULL,
  `lng` DECIMAL(9, 6) NOT NULL,
  `ctime` DECIMAL(13, 3) NOT NULL,
  `user`  int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

desc `index1`;# check the table index1 u create