search

Home  >  Article  >  Database  >  中国城市坐标SQL代码

中国城市坐标SQL代码

WBOY
WBOYOriginal
2016-06-07 14:58:022606browse

中国城市坐标SQL代码 MySQL CREATE TABLE `test_data` ( `id` varchar(50) NOT NULL default '', `province` varchar(100) NOT NULL COMMENT '省级', `city` varchar(100) NOT NULL COMMENT '城市', `county` varchar(100) NOT NULL, `longitude` varchar(20)

中国城市坐标SQL代码 MySQL 
CREATE TABLE `test_data` (
  `id` varchar(50) NOT NULL default '',
  `province` varchar(100) NOT NULL COMMENT '省级',
  `city` varchar(100) NOT NULL COMMENT '城市',
  `county` varchar(100) NOT NULL,
  `longitude` varchar(20) NOT NULL,
  `latitude` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

具体代码下载附件
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：可以提取表的结构信息Next article：Oracle数据库中找出空表

Related articles

See more