SQL insert into student values 后面括号里的格式是怎样的? [问题点数:40分,结帖人Alex_SHT_JAVA]

Bbs1
本版专家分:0
结帖率 100%
Bbs7
本版专家分:19382
Blank
红花 2011年10月 Java大版内专家分月排行榜第一
Blank
蓝花 2011年9月 Java大版内专家分月排行榜第三
Bbs1
本版专家分:20
Bbs2
本版专家分:343
Bbs9
本版专家分:57683
Blank
黄花 2011年12月 Java大版内专家分月排行榜第二
2011年11月 Java大版内专家分月排行榜第二
2010年9月 Java大版内专家分月排行榜第二
Blank
蓝花 2011年10月 Java大版内专家分月排行榜第三
Bbs1
本版专家分:0
Bbs7
本版专家分:19382
Blank
红花 2011年10月 Java大版内专家分月排行榜第一
Blank
蓝花 2011年9月 Java大版内专家分月排行榜第三
Bbs1
本版专家分:0
Bbs1
本版专家分:0
Bbs9
本版专家分:57683
Blank
黄花 2011年12月 Java大版内专家分月排行榜第二
2011年11月 Java大版内专家分月排行榜第二
2010年9月 Java大版内专家分月排行榜第二
Blank
蓝花 2011年10月 Java大版内专家分月排行榜第三
Bbs7
本版专家分:19382
Blank
红花 2011年10月 Java大版内专家分月排行榜第一
Blank
蓝花 2011年9月 Java大版内专家分月排行榜第三
Bbs9
本版专家分:53927
Blank
黄花 2011年5月 Java大版内专家分月排行榜第二
2011年3月 Java大版内专家分月排行榜第二
2010年11月 Java大版内专家分月排行榜第二
2010年10月 Java大版内专家分月排行榜第二
Blank
蓝花 2012年2月 Java大版内专家分月排行榜第三
2011年8月 Java大版内专家分月排行榜第三
2011年6月 Java大版内专家分月排行榜第三
2011年4月 Java大版内专家分月排行榜第三
2010年12月 Java大版内专家分月排行榜第三
SQL INSERT INTO
SQL INSERT INTO 语句    INSERT INTO 语句用于向表中插入新记录 SQL INSERT INTO 语法    INSERT INTO 语句可以有两种编写形式    1)无需指定要插入数据的列名,只需提供被插入的值即可: INSERT INTO table_name VALUES (value1,value2,value3,...);    2)需要指定列名...
Sql Server insert into 添加数据
Sql Server Insert into 添加数据基本语法 基本语法 INSERT INTO 表名称 VALUES (值1, 值2,....) --插入单条数据,全字段都要有值 INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....) --插入单条数据 部分字段,部分值 INSERT INTO table_name (列1, 列2...
SQL中用insert into插入一行或多行记录
INSERT INTO插入一行记录:         INSERT INTO tablename <em>values</em>(v1,v2,...);  --这里需包括所有列的值    若只向指定列插入值:         INSERT INTO tablename (column1,column3) <em>values</em>(v1,v3); INSERT INTO插入多行记录:      若数据来自另一张表
【mysqlinsert的几种方式
笔者创建的<em>student</em>表,总共三个字段(<em>student</em>Id是主键)rnrnrn一、往<em>student</em>_info表中插入一条数据rn<em>insert</em> into <em>student</em>_info <em>values</em>(5,'liutao',12);rn//主键手动定义rn报错 Error Code : 1062 Duplicate entry '5' for key 'PRIMARY',这里就是因为你的主键重复了rnrn
#数据库操作tips#执行insert语句,参数太多时将insert语句格式
在完成学校布置的大作业中,需要对数据库中的一个表进行<em>insert</em>操作,这个表记录了员工信息,表如下:nnnnn一般情况下执行<em>insert</em>语句会考虑用PreparedStatement,因为参数未知,需要传入引用值。n这个表中有九个属性,在添加员工时,如果用PreparedStatement来执行插入语句,则会是这样的:nString <em>sql</em> = "<em>insert</em> inton staf
insert into 表, 插入变量
public void actionRemove_actionPerformed(ActionEvent e) throws Exceptionn {n if(BillStatusEnum.Audit.equals(this.editData.getBillStatus())){n MsgBox.showInfo(&quot;已审核的单据不允许删除!&quot;);n SysUti...
SQL Server数据库第三课:SQL语言介绍、使用INSERT向表中插入数据、使用UPDATE更新表中数据、使用DELETE删除表中数据
知识点:SQL语言的作用、SQL语言的组成、SQL中的运算符、使用INSERT向表中插入数据、使用UPDATE更新表中数据、使用DELETE删除表中数据。nn1、SQL简介nn1.1 什么是SQL?nn Structured Query Language:结构化查询语言nnSQL 指结构化查询语言n SQL 使我们有能力访问数据库n SQL 是一种 ANSI 的标准计算机语言(注释:...
iBatis工程简单例子
iBatis工程的简单例子,在eclipse上实现的,数据库是my<em>sql</em>数据库,里面的字段为CREATE DATABASE MYDB; use MYDB; Drop TABLE IF EXISTS `MYDB`.`<em>student</em>`; Create TABLE `MYDB`.`<em>student</em>` ( `name` varchar(40) NOT NULL, `psw` varchar(10) NOT NULL, `enabled` boolean ); <em>insert</em> into <em>student</em> <em>values</em>("lanp","lanpiao",true); <em>insert</em> into <em>student</em> <em>values</em>("ph","ph",true); <em>insert</em> into <em>student</em> <em>values</em>("wxh","wxh",true);
struts2 分页
DROP DATABASE IF EXISTS page; CREATE DATABASE page ; USE page; CREATE TABLE <em>student</em> ( stu_id INTEGER AUTO_INCREMENT, stuName VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, stuPhone VARCHAR(255)NOT NULL, PRIMARY KEY(stu_id) ); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('杨华林','长沙','13787825190'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('李明清','天津','13787525190'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('李小华','大连','13788451190'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('郑小明','苏州','13787052188'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('杨一新','西安','13787851190'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('王新任','广州','13787056460'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('谢小华','深圳','13787075550'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('王建明','厦门','13788853690'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('秦一生','北京','13788689236'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('田翠林','杭州','13787655150'); INSERT INTO <em>student</em>(stuName,address,stuPhone) VALUES('陈小明','广州','13787623668');
insert into语句中的引号问题的一点理解
对于这个问题,这篇文章讲的非常好https://blog.csdn.net/suboysugar/article/details/5442848,其中提到了一个小窍门,可以将下面的语句题换成变量的写法:nnstr<em>sql</em>=“Insert into mytable(username) <em>values</em>(‘张红’)”n           第一步:先把张红抹去,在原位置加两个引号n           st...
Struts2_Hibernate3_Freemak
Framework: struts2 & hibernate3.0 & freemak & my<em>sql</em> create table Student( id int identity primary key, sex varchar(10), name varchar(50), address varchar(30); score float(10) ); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('1','haojie','深圳罗湖',1.3); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('0','tim','福田',2.3); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('1','aaa','南山',3.3); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('0','bbb','深圳',4.3); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('1','ccc','罗湖',5.3); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('0','ddd','盐田',6.3); <em>insert</em> into Student(sex,name,address,score) <em>values</em>('1','eee','宝安',7.3);
SQL项目代码
问题及描述: --1.学生表 Student(S#,Sname,Sage,Ssex) --S# 学生编号,Sname 学生姓名,Sage 出生年月,Ssex 学生性别 --2.课程表 Course(C#,Cname,T#) --C# --课程编号,Cname 课程名称,T# 教师编号 --3.教师表 Teacher(T#,Tname) --T# 教师编号,Tname 教师姓名 --4.成绩表 SC(S#,C#,score) --S# 学生编号,C# 课程编号,score 分数 */ --创建测试数据 create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10)) <em>insert</em> into Student <em>values</em>('01' , N'赵雷' , '1990-01-01' , N'男') <em>insert</em> into Student <em>values</em>('02' , N'钱电' , '1990-12-21' , N'男') <em>insert</em> into Student <em>values</em>('03' , N'孙风' , '1990-05-20' , N'男') <em>insert</em> into Student <em>values</em>('04' , N'李云' , '1990-08-06' , N'男') <em>insert</em> into Student <em>values</em>('05' , N'周梅' , '1991-12-01' , N'女') <em>insert</em> into Student <em>values</em>('06' , N'吴兰' , '1992-03-01' , N'女') <em>insert</em> into Student <em>values</em>('07' , N'郑竹' , '1989-07-01' , N'女') <em>insert</em> into Student <em>values</em>('08' , N'王菊' , '1990-01-20' , N'女') create table Course(C# varchar(10),Cname nvarchar(10),T# varchar(10)) <em>insert</em> into Course <em>values</em>('01' , N'语文' , '02') <em>insert</em> into Course <em>values</em>('02' , N'数学' , '01') <em>insert</em> into Course <em>values</em>('03' , N'英语' , '03') create table Teacher(T# varchar(10),Tname nvarchar(10)) <em>insert</em> into Teacher <em>values</em>('01' , N'张三') <em>insert</em> into Teacher <em>values</em>('02' , N'李四') <em>insert</em> into Teacher <em>values</em>('03' , N'王五') create table SC(S# varchar(10),C# varchar(10),score decimal(18,1)) <em>insert</em> into SC <em>values</em>('01' , '01' , 80) <em>insert</em> into SC <em>values</em>('01' , '02' , 90) <em>insert</em> into SC <em>values</em>('01' , '03' , 99) <em>insert</em> into SC <em>values</em>('02' , '01' , 70)
scala将csv转换成insert语句
工作中自己写的一个简单的scala小工具类,主要对字符类型的字段在拼装SQL时加引号,null值在csv文件力的几种形式。rn如果数据量比较小,可以直接<em>insert</em>进去的库,又不方便直接导入文件的(比如某环境某库某服务被某破人禁用,库还出问题了,只能通过其他途径<em>insert</em>进去QAQ)就有用了。rn用scala写的,其他语言都差不多啦。rnrnrnrnpackage csvInsertSQLSer
Mysql,Sql练习题(整理中,整合了网上了一些试题和面试书上内容)
##测试数据 my<em>sql</em>rnrnrncreate table Student(rnSid varchar(10),rnSname varchar(10),rnSage datetime,rnSsex varchar(10)rn);rnrnrn<em>insert</em> into Student <em>values</em>('01' , '赵雷' , '1990-01-01' , '男');rn<em>insert</em> into Stud
05.MySQL之多表操作
外键:准备:创建两张表,一个班级表和一个学生表#建库CREATE DATABASE chapter05;#建表USE chapter05;CREATE TABLE grade(    id int(4) NOT NULL PRIMARY KEY,    name varchar(36) ); CREATE TABLE <em>student</em>(    sid int(4) NOT NULL PRIMARY ...
sql当中int后面括号当中的数代表什么意思
在<em>sql</em>语言里面,基本数据类型包括:数值型、字符型、日期型、大文本型;其中int是数值型里面的整数类型。在建表的时候使用int来表示一个整型的属性;n而int(10)则表示长度最长为10位的整型属性;n带<em>括号</em>和不带<em>括号</em>主要是对最大长度的限制不同。
sql 对插入、删除、修改、查询进行类封装
包名排列<em>student</em>类package sdut.po;nnpublic class Student { n n private int id; n private String name; n private int age; n n public Student() {n }n public Student(int id, String name, ...
INSERT 语句中列的数目大于 VALUES 子句中指定的值的数目。VALUES 子句中值的数目必须与 INSERT 语句中指定的列的数目匹配。
前言n机房调错是一个从痛苦到快乐的过程,而我正在这条道路上这不今天在敲基础设定窗体的时候就蹦出来了这么个错误nnnnn原因n 其实啊很简单的,原因就是要插入BasicData_Info表时多了一个参数UserId 而下方没有接受的,在传入的时候出现了不匹配的现象。n n结局n将D层对应的SQL语句中将UserId删除就OK了如下图nnnnn结语n遇见问题一定要心平气
insert into student values('**');
<em>student</em>表中现只有NAME字段rn我在 SQL PLUS 中执行该语句能成功插入记录rn并可用SELECT * FROM STUDENT;rn查询到正确结果!rnrn问题在于我关闭SQL PLUS后再登陆查询时,表里已无记录了(空)!rn不懂,请教??反复实验亦如此!!
建立表命令
CREATE TABLE Student (Sno CHAR(9) PRIMARY KEY, Sname CHAR(20) UNIQUE, Ssex CHAR(2), Sage SMALLINT, Sdept CHAR(20)); <em>insert</em> into <em>student</em> <em>values</em>('20...
1101学习记录!!!一定切记,executeUpdate后面括号中不要添加strSql
package com.company;nnimport java.<em>sql</em>.*;nnn/**n * Created by ttc on 16-11-1.n */npublic class Insertn{n public static void <em>insert</em>User(UserInfo ui) throws ClassNotFoundException, SQLExceptionn {n
SQL语法:insert values批量插入
例如:CREATE TABLE &quot;websites&quot; (  &quot;id&quot; int  NOT NULL  ,  &quot;name&quot; char(20) NOT NULL DEFAULT ''  ,  &quot;url&quot; varchar(255) NOT NULL DEFAULT '',  &quot;alexa&quot; int  NOT NULL DEFAULT '0' ,  &quot;country&quot; char(10) NOT NU
sql使用小技巧之INSERT INTO SELECT 语句的使用心得了解下
INSERT INTO SELECT 语句的主要作用就是从一个表复制数据,然后把数据插入到一个已存在的表中,且目标表中任何已存在的行都不会受影响。它的语法有两种,如下:nnn从一个表中复制所有的列插入到另一个已存在的表中:nINSERT INTO table2nSELECT * FROM table1;nn只复制希望的列插入到另一个已存在的表中:nINSERT INTO table2n(colum...
sql脚本批量插入
Insert into Student(Sno,Sname,Ssex,Sage,sdept) rnselect '95001','李勇','男','20','CS' union allrnselect '95002','刘晨','女','19','IS' union allrn...... rnselect '96003','李四','男',18,'IS'
insert into 实现插入 或者满足条件更新实例
插入 或者满足条件更新rnrnrnrn<em>insert</em> into dict_itagtel_test_zhao(`field1`,`field2`,`field3`,`field5`,`field6`)n<em>values</em>("86","1","100","2017-08-15 19:43:11","15298837172"),n("86","1","100","2017-08-15 19:43:11","0
SQL的插入语句insert
插入数据分为以下几种方式:rnrnrn1. 插入完整的行;rn2. 插入行的一部分rn3. 插入某些查询的结果rn4. 从一个表复制到另一个表rnrnrnrn1. 插入完整的行,有两种方式:rn   INSERT  INTO  Customers  VALUES ();                                   // 缺点:高度依赖表中列的定义次序,不能保证各列在下一次表
如何用insert into values插入多条数据
INSERT INTO 语句nnINSERT INTO 语句用于向表格中插入新的行。nnnn语法:第一种形式无需指定要插入数据的列名,只需提供被插入的值即可:nnINSERT INTOtable_namennVALUES (value1,value2,value3,...);nn例子:nn <em>insert</em> into [Test].[dbo].[SQLTEST]n ...
insert中使用子查询
主要子查询返回的是一个字段即可:INSERT INTO t_upsNode(rncompanyId, stateId, upsId, originalUpsName, isActivate, upsManufactIdrn, upsModelId, upsVersion, agentVersion, ip, PORT, mac, memo, capabilityrn, configOutputPo
为何不建议用 insert values() 的sql句式
好久没写博客了,是懒癌,得治,可是癌症治得了吗。rn入正题!rn最近在写需求,遇到了bug,也许格格和八阿哥的爱恨情仇只有程序猿能懂rn入正题!rn根据日志,找到bug,具体的就是一条插入语句为 <em>insert</em>  <em>values</em>() 句式。rn日志提示为少字段。但是这个程序一直都没有改过的。咋突然不灵了???,心里有一匹马飞奔而过rn查了一下插入表的表结构,确实少了字段。追溯历史后终于明了,此表后来由
Oracle中以insert values的形式同时插入多条记录
由于要做测试数据插oracle数据库,想到了my<em>sql</em>的多个<em>values</em>的形式,但是<em>sql</em>报错。oracle并不支持这种一个<em>insert</em> into 多个<em>values</em>的方法[<em>sql</em>] view plain copyINSERT INTO users(name, age) VALUES('ccc', 333), ('aaa', 222), ('bbb', 111);  但是有另一种写法,做个简单记录,...
insert into插入数据
<em>insert</em> into 表名称 <em>values</em>(值1,值2,...) rnrn可以指定所要插入数据的列:rnrnINSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)rnrnrn遇到了个自己都想不到的错误,rn我一定是没睡醒
关于JDBC+MySQL批量写入: 用insert values方式批量写入
<em>insert</em> <em>values</em> 方式 my<em>sql</em> 批量写入
建立学生-课程模式S-T
·学生表:Student(Sno,Sname,Ssex,Sage,Sdept)·课程表:Course(Cno,Cname,Cpno,Ccredit)·学生选课表CS(Sno,Cno,Grade)建立表命令:CREATE TABLE Student n n (Sno CHAR(9) PRIMARY KEY, n n Sname CHAR...
Oracle中简单的SQL查询语句练习
#建学生信息表<em>student</em>create table <em>student</em>(sno varchar(20) not null primary key,sname varchar(20) not null,ssex varchar(20) not null,sbirthday DATE,class varchar(20));#建立教师表create table teacher(tno varchar(20...
php登录注册接口
n n n 了解JSONnnJSON 指的是 JavaScript 对象表示法(JavaScript Object Notation)nJSON 是轻量级的文本数据交换<em>格式</em>nJSON 独立于语言nJSON 具有自我描述性,更易理解nnJSON 是存储和交换文本信息的语法。类似 XML。nJSON 比 XML 更小、更快,更易解析。n<em>格式</em>转化n学习了php的基本语法的你...
SQL语句中别名中有括号的情况
select Alone as A from table where ……没有问题rn    select Alone as A(bcde) from table where ……有问题rn    改为以下语句:rn    select Alone as "A(bcde)" from table where……问题解决了
【mysqlinsert 数据插入
一:插入语句<em>insert</em> into 表名 [column 1,column 2,……,column n]<em>values</em>(a_1,b_1,……,x_1),……(a_n,b_n,……,x_n);二:<em>student</em>表格的数据插入例子以表<em>student</em>为例,实现<em>insert</em>语句数据插入:Student学号(sno)姓名(sname)性别(ssex)年龄(sage)所在系(sdept)201215121李勇男...
Oracle SQL内置函数大全
SQL> create table table1(xm varchar(8)); SQL> <em>insert</em> into table1 <em>values</em>('weather'); SQL> <em>insert</em> into table1 <em>values</em>('wether'); SQL> <em>insert</em> into table1 <em>values</em>('gao'); SQL> select xm from table1 where soundex(xm)=soundex('weather');
scanf括号格式的用法
1、用scanf输入数字1,2,3,然后进行打印nnn#include &amp;lt;stdio.h&amp;gt;nnint main()n{n int a=1,b=2,c=3;nn scanf(&quot;%d%d%d&quot;,&amp;amp;a,&amp;amp;b,&amp;amp;c);n printf(&quot;a=%d b=%d c=%d\n&quot;,a,b,c);nn return 0;n}nnn打印结果:nnnn2、sc...
INSERT INTO 中的一种子查询
INSERT 语句中的 SELECT 子查询可用于将一个或多个表或视图中的值添加到另一个表中。使用 SELECT 子查询还可以同时插入多行. INSERT INTO 表名 as a (n a.列1,a.列2,a.列3...n )n SELECT n b.列1,b.列2,b.列3... n FROM 表名 as bn WHERE 条件;注意:
mysql8基础 insert values 一次插入多条语句
    &amp;nbsp;&amp;nbsp; OS : Ubuntu 18.04.1 LTSn  &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DBMS : my<em>sql</em> 8.0.12n   &amp;nbsp;&amp;nbsp;&amp;nbsp; blog : blog.csdn.net/shiwanwun typesetting : Markdownnn nn数据,数据,命根就在数据 ! 操作数据库时,一定要谨慎小心。师...
sql where条件语句中同时包含and,or注意加括号
在测试程序的时候发现<em>sql</em>查询语句超过范围检查<em>sql</em>语句发现原语句:select xx from xx where a=b and c=d or e=f;预期的结果是满足a=b的同时c=d或者e=f,忘记加<em>括号</em>导致范围超限加<em>括号</em>后select xx from xx where a=b and (c=d or e=f);问题随小,还是值得注意...
MySQL Err : insert时忘记给values中非字符型值加引号。。。
问题:<em>insert</em>时忘记给<em>values</em>中非字符型值加引号
oracle 使用with insert插入数据的问题
今天有个写存储过程的朋友问我一个with a  as  。。。。<em>insert</em> 的存储过程为什么总是报错:ORA-00928: 缺失 SELECT 关键字rnrnrn最后发现with<em>后面</em>只能直接跟select 不能跟<em>insert</em>,修改后解决问题rnrnrn修改前:rnwithrn a as(SELECT T.StationId,U.Id AS UserId rnFROM Sys_Station_In
数据库中增加操作insert into的用法和查询select的用法
<em>insert</em> into的用法n1.一条<em>insert</em> into 可以插入多条记录nnnnnnnnn2.<em>insert</em> into 能判断主键是否冲突,和做出冲突处理nnn如果主键冲突的话会报错,n还能写成如果冲突就更新的形式n<em>格式</em>为  : <em>insert</em> into 表名 (字段列表) <em>values</em> (字段值列表) on duplicate key update 字段=值,字段
SQL Server程序设计 实验答案
SQL Server程序设计 实验答案 <em>insert</em> teach_class <em>values</em>('t05001','080501','c05109') alter table <em>student</em> add nation varchar(10) alter table <em>student</em> alter column nation varchar(12) alter table <em>student</em> drop column nation
sql语句and后面加不加括号的区别
select * from a where conditiona and conditionb or conditioncn此时查询的结果集 同时满足conditiona 和 conditionb 或者只满足conditioncnnselect * from a where conditiona and (conditionb or conditionc)n此时查询的结果集 满足conditi...
oracle不支持inser into values写法的批量插入
mybatis在oracle中批量插入数据时,单次批量大小有限制,批量插入时,单次批量过大,也会影响插入性能。故程序端也需要对应的限制。[html] view plain copy &amp;lt;<em>insert</em> id=&quot;addBatch&quot; parameterType=&quot;java.util.List&quot;&amp;gt;      BEGIN      &amp;lt;foreach collection=&quot;list&quot; ite...
mybatise框架sql语句中trim的使用
看到一块代码,第一次见到trim这种标签,于是开始研究了:n <em>insert</em> into usern n
insert into 语句的三种写法
<em>insert</em> into 语句的三种写法n方式1. INSERT INTO t1(field1,field2) VALUES(v001,v002);nn方式2. INSERT INTO t1(field1,field2) VALUES(v101,v102),(v201,v202),(v301,v302),(v401,v402);n在插入批量数据时方式2优于方式1.nnnn方式3.1
记MyBatis和MySQL中遇到的一些小问题
问题:rnrnorg.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'top.kittygirl.xdtoutiao.InitDatabaseTests': Unsatisfied dependency expressed through field 'user
Insert语句的几个提高效率的特殊用法
我们做Insert操作的,经常要判断<em>insert</em>的条件是否满足。一般的做法,都会先执行一条判断语句,然后再执行<em>insert</em>语句,下面的方法可以帮助你节省第一条判断语句,把这两者结合到一起完成。rnrn测试表: create table ccc (id int primary key, name varchar(100));rnrn1. on duplicate key update column...
sql语句中or条件有无括号举例!!
select * from school where class=1 and (sex like 男 or birthday like 1);                     rn or在<em>括号</em>里面,结果集是班级1后再加过滤条件是男生或生日在1月份得到的;rnselect * from school where class=1 and sex like 男 or birthday like
PL/SQL:通过select数据来源表返回的数据结果insert到目标表上:sys_guid()对应的id不一致
1、设置新表的id的Default值为:sys_guid(),nullable为空nn2、<em>insert</em>的<em>sql</em>语句数据源:select数据来源表的时候,不用再带sys_guid(),而目标表的<em>insert</em> into,不用带上idnn目标表:nnncreate table T_SYS_USER_ROLEn(n ID VARCHAR2(75) default sys_guid() not ...
mysqlinsert into语句的6种写法(上)
<em>insert</em> into是my<em>sql</em>中最常用的插入语句,它有6种写法。下面让我们一起来看一看吧:nnnnnnmy<em>sql</em>中<em>insert</em> into语句的6种写法(下)nnhttp://blog.csdn.net/number1killer/article/details/77842472nnnn1向原表中某些字段中插入一条记录。nn语法:<em>insert</em> into +表名(表中的字段,,)value...
Oracle中以insert values的形式同时插入多条记录(批处理操作insert、update、delete)
 nn以<em>insert</em> <em>values</em>实现批量插入数据n由于要做测试数据插oracle数据库,想到了my<em>sql</em>的多个<em>values</em>的形式,但是<em>sql</em>报错。oracle并不支持这种一个<em>insert</em> into 多个<em>values</em>的方法nnINSERT INTO users(name, age) VALUES('ccc', 333), ('aaa', 222), ('bbb', 111);  nn但是有另一种写...
int和varchar后面数字的含义
int和varchar<em>后面</em>数字的含义int(1)、tinyint(4) 哪个大? nint 大。 n注意数字类型<em>后面</em><em>括号</em>中的数字,不表示长度,表示的是显示宽度,这点与 varchar、char <em>后面</em>的数字含义是不同的。 n也就是说不管 int <em>后面</em>的数字是多少,它存储的范围始终是 -2^31 到 2^31 - 1。综上整型的数据类型<em>括号</em>内的数字不管是多少,所占的存储空间都是一样 ntinyint一个
ORA-00907: 缺失右括号;代码我在sql运行中都正确,但到了idea中就报错
这代码我在<em>sql</em>运行中都正确,但到了idea中就报错n我觉得是子查询中那个order by的毛病,但分页语法必须有nSELECT PP.EMP_CODE,nE.NAME,nPP.EMP_SEQ_NUM,nPP.ORG_NAME,nPP.EMP_PROPERTY,nPP.EMP_TYPE,nPP.EMP_ORG_ID,nPP.IDnFROM (SELECT T.ID,nT.IS_DELETED,nT...
身份证归属地数据(sql文件)
INSERT INTO area_code_info VALUES('110100','北京市市辖区') INSERT INTO area_code_info VALUES('110101','北京市东城区') INSERT INTO area_code_info VALUES('110102','北京市西城区') INSERT INTO area_code_info VALUES('110103','北京市崇文区') INSERT INTO area_code_info VALUES('110104','北京市宣武区') INSERT INTO area_code_info VALUES('110105','北京市朝阳区') INSERT INTO area_code_info VALUES('110106','北京市丰台区') INSERT INTO area_code_info VALUES('110107','北京市石景山区') INSERT INTO area_code_info VALUES('110108','北京市海淀区') INSERT INTO area_code_info VALUES('110109','北京市门头沟区') INSERT INTO area_code_info VALUES('110111','北京市房山区') INSERT INTO area_code_info VALUES('110112','北京市通州区') INSERT INTO area_code_info VALUES('110113','北京市顺义区') ……………………
SQL语句练习题集合
类京东练习题创建数据库、创建表-- 创建 &quot;京东&quot; 数据库ncreate database jing_dong charset=utf8;nn-- 使用 &quot;京东&quot; 数据库nuse jing_dong;nn-- 创建一个商品goods数据表ncreate table goods(n id int unsigned primary key auto_increment not null,n ...
中国省市区.txt
CREATE TABLE sys_city ( id int NOT NULL , areaname varchar(24) NULL , parentid int DEFAULT NULL, ) INSERT INTO sys_city VALUES ('110000', '北京市', '0'); INSERT INTO sys_city VALUES ('110101', '东城区', '110100'); INSERT INTO sys_city VALUES ('110102', '西城区', '110100'); INSERT INTO sys_city VALUES ('110105', '朝阳区', '110100'); INSERT INTO sys_city VALUES ('110106', '丰台区', '110100'); INSERT INTO sys_city VALUES ('110107', '石景山区', '110100'); INSERT INTO sys_city VALUES ('110108', '海淀区', '110100'); INSERT INTO sys_city VALUES ('110109', '门头沟区', '110100'); INSERT INTO sys_city VALUES ('110111', '房山区', '110100'); INSERT INTO sys_city VALUES ('110112', '通州区', '110100'); INSERT INTO sys_city VALUES ('110113', '顺义区', '110100'); INSERT INTO sys_city VALUES ('110114', '昌平区', '110100'); INSERT INTO sys_city VALUES ('110115', '大兴区', '110100'); INSERT INTO sys_city VALUES ('110116', '怀柔区', '110100'); INSERT INTO sys_city VALUES ('110117', '平谷区', '110100'); INSERT INTO sys_city VALUES ('110228', '密云区', '110200'); INSERT INTO sys_city VALUES ('110229', '延庆区', '110200'); INSERT INTO sys_city VALUES ('120000', '天津市', '0'); INSERT INTO sys_city VALUES ('120101', '和平区', '120100'); INSERT INTO sys_city VALUES ('120102', '河东区', '120100'); INSERT INTO sys_city VALUES ('120103', '河西区', '120100'); INSERT INTO sys_city VALUES ('120104', '南开区', '120100'); INSERT INTO sys_city VALUES ('120105', '河北区', '120100'); INSERT INTO sys_city VALUES ('120106', '红桥区', '120100'); INSERT INTO sys_city VALUES ('120110', '东丽区', '120100'); INSERT INTO sys_city VALUES ('120111', '西青区', '120100'); INSERT INTO sys_city VALUES ('120112', '津南区', '120100'); INSERT INTO sys_city VALUES ('120113', '北辰区', '120100'); INSERT INTO sys_city VALUES ('120114', '武清区', '120100'); INSERT INTO sys_city VALUES ('120115', '宝坻区', '120100'); INSERT INTO sys_city VALUES ('120116', '滨海新区', '120100'); INSERT INTO sys_city VALUES ('120221', '宁河区', '120200'); INSERT INTO sys_city VALUES ('120223', '静海区', '120200'); INSERT INTO sys_city VALUES ('120225', '蓟县', '120200'); INSERT INTO sys_city VALUES ('130000', '河北省', '0'); INSERT INTO sys_city VALUES ('130100', '石家庄市', '130000'); INSERT INTO sys_city VALUES ('130102', '长安区', '130100'); INSERT INTO sys_city VALUES ('130104', '桥西区', '130100'); INSERT INTO sys_city VALUES ('130105', '新华区', '130100'); INSERT INTO sys_city VALUES ('130107', '井陉矿区', '130100'); INSERT INTO sys_city VALUES ('130108', '裕华区', '130100'); INSERT INTO sys_city VALUES ('130109', '藁城区', '130100'); INSERT INTO sys_city VALUES ('130110', '鹿泉区', '130100'); INSERT INTO sys_city VALUES ('130111', '栾城区', '130100'); INSERT INTO sys_city VALUES ('130121', '井陉县', '130100'); INSERT INTO sys_city VALUES ('130123', '正定县', '130100'); INSERT INTO sys_city VALUES ('130125', '行唐县', '130100'); INSERT INTO sys_city VALUES ('130126', '灵寿县', '130100'); INSERT INTO sys_city VALUES ('130127', '高邑县', '130100'); INSERT INTO sys_city VALUES ('130128', '深泽县', '130100'); INSERT INTO sys_city VALUES ('130129', '赞皇县', '130100'); INSERT INTO sys_city VALUES ('130130', '无极县', '130100'); INSERT INTO sys_city VALUES ('130131', '平山县', '130100'); INSERT INTO sys_city VALUES ('130132', '元氏县', '130100'); INSERT INTO sys_city VALUES ('130133', '赵县', '130100'); INSERT INTO sys_city VALUES ('130181', '辛集市', '130100'); INSERT INTO sys_city VALUES ('130183', '晋州市', '130100'); INSERT INTO sys_city VALUES ('130184', '新乐市', '130100'); INSERT INTO sys_city VALUES ('130200', '唐山市', '130000'); INSERT INTO sys_city VALUES ('130202', '路南区', '130200'); INSERT INTO sys_city VALUES ('130203', '路北区', '130200'); INSERT INTO sys_city VALUES ('130204', '古冶区', '130200'); INSERT INTO sys_city VALUES ('130205', '开平区', '130200'); INSERT INTO sys_city VALUES ('130207', '丰南区', '130200'); INSERT INTO sys_city VALUES ('130208', '丰润区', '130200'); INSERT INTO sys_city VALUES ('130209', '曹妃甸区', '130200'); INSERT INTO sys_city VALUES ('130223', '滦县', '130200'); INSERT INTO sys_city VALUES ('130224', '滦南县', '130200'); INSERT INTO sys_city VALUES ('130225', '乐亭县', '130200'); INSERT INTO sys_city VALUES ('130227', '迁西县', '130200'); INSERT INTO sys_city VALUES ('130229', '玉田县', '130200'); INSERT INTO sys_city VALUES ('130281', '遵化市', '130200'); INSERT INTO sys_city VALUES ('130283', '迁安市', '130200'); INSERT INTO sys_city VALUES ('130300', '秦皇岛市', '130000'); INSERT INTO sys_city VALUES ('130302', '海港区', '130300'); INSERT INTO sys_city VALUES ('130303', '山海关区', '130300'); INSERT INTO sys_city VALUES ('130304', '北戴河区', '130300'); INSERT INTO sys_city VALUES ('130321', '青龙满族自治县', '130300'); INSERT INTO sys_city VALUES ('130322', '昌黎县', '130300'); INSERT INTO sys_city VALUES ('130323', '抚宁县', '130300'); INSERT INTO sys_city VALUES ('130324', '卢龙县', '130300'); INSERT INTO sys_city VALUES ('130400', '邯郸市', '130000'); INSERT INTO sys_city VALUES ('130402', '邯山区', '130400'); INSERT INTO sys_city VALUES ('130403', '丛台区', '130400'); INSERT INTO sys_city VALUES ('130404', '复兴区', '130400'); INSERT INTO sys_city VALUES ('130406', '峰峰矿区', '130400'); INSERT INTO sys_city VALUES ('130421', '邯郸县', '130400'); INSERT INTO sys_city VALUES ('130423', '临漳县', '130400'); INSERT INTO sys_city VALUES ('130424', '成安县', '130400'); INSERT INTO sys_city VALUES ('130425', '大名县', '130400'); INSERT INTO sys_city VALUES ('130426', '涉县', '130400'); INSERT INTO sys_city VALUES ('130427', '磁县', '130400'); INSERT INTO sys_city VALUES ('130428', '肥乡县', '130400'); INSERT INTO sys_city VALUES ('130429', '永年县', '130400'); INSERT INTO sys_city VALUES ('130430', '邱县', '130400'); INSERT INTO sys_city VALUES ('130431', '鸡泽县', '130400'); INSERT INTO sys_city VALUES ('130432', '广平县', '130400'); INSERT INTO sys_city VALUES ('130433', '馆陶县', '130400'); INSERT INTO sys_city VALUES ('130434', '魏县', '130400'); INSERT INTO sys_city VALUES ('130435', '曲周县', '130400'); INSERT INTO sys_city VALUES ('130481', '武安市', '130400'); INSERT INTO sys_city VALUES ('130500', '邢台市', '130000'); INSERT INTO sys_city VALUES ('130502', '桥东区', '130500'); INSERT INTO sys_city VALUES ('130503', '桥西区', '130500'); INSERT INTO sys_city VALUES ('130521', '邢台县', '130500'); INSERT INTO sys_city VALUES ('130522', '临城县', '130500'); INSERT INTO sys_city VALUES ('130523', '内丘县', '130500'); INSERT INTO sys_city VALUES ('130524', '柏乡县', '130500'); INSERT INTO sys_city VALUES ('130525', '隆尧县', '130500'); INSERT INTO sys_city VALUES ('130526', '任县', '130500'); INSERT INTO sys_city VALUES ('130527', '南和县', '130500'); INSERT INTO sys_city VALUES ('130528', '宁晋县', '130500'); INSERT INTO sys_city VALUES ('130529', '巨鹿县', '130500'); INSERT INTO sys_city VALUES ('130530', '新河县', '130500'); INSERT INTO sys_city VALUES ('130531', '广宗县', '130500'); INSERT INTO sys_city VALUES ('130532', '平乡县', '130500'); INSERT INTO sys_city VALUES ('130533', '威县', '130500'); INSERT INTO sys_city VALUES ('130534', '清河县', '130500'); INSERT INTO sys_city VALUES ('130535', '临西县', '130500'); INSERT INTO sys_city VALUES ('130581', '南宫市', '130500'); INSERT INTO sys_city VALUES ('130582', '沙河市', '130500'); INSERT INTO sys_city VALUES ('130600', '保定市', '130000'); INSERT INTO sys_city VALUES ('130602', '竞秀区', '130600'); INSERT INTO sys_city VALUES ('130604', '南市区', '130600'); INSERT INTO sys_city VALUES ('130606', '莲池区', '130600'); INSERT INTO sys_city VALUES ('130607', '满城区', '130600'); INSERT INTO sys_city VALUES ('130608', '清苑区', '130600'); INSERT INTO sys_city VALUES ('130609', '徐水区', '130600'); INSERT INTO sys_city VALUES ('130623', '涞水县', '130600'); INSERT INTO sys_city VALUES ('130624', '阜平县', '130600'); INSERT INTO sys_city VALUES ('130626', '定兴县', '130600'); INSERT INTO sys_city VALUES ('130627', '唐县', '130600'); INSERT INTO sys_city VALUES ('130628', '高阳县', '130600'); INSERT INTO sys_city VALUES ('130629', '容城县', '130600'); INSERT INTO sys_city VALUES ('130630', '涞源县', '130600'); INSERT INTO sys_city VALUES ('130631', '望都县', '130600'); INSERT INTO sys_city VALUES ('130632', '安新县', '130600'); INSERT INTO sys_city VALUES ('130633', '易县', '130600'); INSERT INTO sys_city VALUES ('130634', '曲阳县', '130600'); INSERT INTO sys_city VALUES ('130635', '蠡县', '130600'); INSERT INTO sys_city VALUES ('130636', '顺平县', '130600'); INSERT INTO sys_city VALUES ('130637', '博野县', '130600'); INSERT INTO sys_city VALUES ('130638', '雄县', '130600'); INSERT INTO sys_city VALUES ('130681', '涿州市', '130600'); INSERT INTO sys_city VALUES ('130682', '定州市', '130600'); INSERT INTO sys_city VALUES ('130683', '安国市', '130600'); INSERT INTO sys_city VALUES ('130684', '高碑店市', '130600'); INSERT INTO sys_city VALUES ('130700', '张家口市', '130000'); INSERT INTO sys_city VALUES ('130702', '桥东区', '130700'); INSERT INTO sys_city VALUES ('130703', '桥西区', '130700'); INSERT INTO sys_city VALUES ('130705', '宣化区', '130700'); INSERT INTO sys_city VALUES ('130706', '下花园区', '130700'); INSERT INTO sys_city VALUES ('130721', '宣化县', '130700'); INSERT INTO sys_city VALUES ('130722', '张北县', '130700'); INSERT INTO sys_city VALUES ('130723', '康保县', '130700'); INSERT INTO sys_city VALUES ('130724', '沽源县', '130700'); INSERT INTO sys_city VALUES ('130725', '尚义县', '130700'); INSERT INTO sys_city VALUES ('130726', '蔚县', '130700'); INSERT INTO sys_city VALUES ('130727', '阳原县', '130700'); INSERT INTO sys_city VALUES ('130728', '怀安县', '130700'); INSERT INTO sys_city VALUES ('130729', '万全县', '130700'); INSERT INTO sys_city VALUES ('130730', '怀来县', '130700'); INSERT INTO sys_city VALUES ('130731', '涿鹿县', '130700'); INSERT INTO sys_city VALUES ('130732', '赤城县', '130700'); INSERT INTO sys_city VALUES ('130733', '崇礼县', '130700'); INSERT INTO sys_city VALUES ('130800', '承德市', '130000'); INSERT INTO sys_city VALUES ('130802', '双桥区', '130800'); INSERT INTO sys_city VALUES ('130803', '双滦区', '130800'); INSERT INTO sys_city VALUES ('130804', '鹰手营子矿区', '130800'); INSERT INTO sys_city VALUES ('130821', '承德县', '130800'); INSERT INTO sys_city VALUES ('130822', '兴隆县', '130800'); INSERT INTO sys_city VALUES ('130823', '平泉县', '130800'); INSERT INTO sys_city VALUES ('130824', '滦平县', '130800'); INSERT INTO sys_city VALUES ('130825', '隆化县', '130800'); INSERT INTO sys_city VALUES ('130826', '丰宁满族自治县', '130800'); INSERT INTO sys_city VALUES ('130827', '宽城满族自治县', '130800'); INSERT INTO sys_city VALUES ('130828', '围场满族蒙古族自治县', '130800'); INSERT INTO sys_city VALUES ('130900', '沧州市', '130000'); INSERT INTO sys_city VALUES ('130902', '新华区', '130900'); INSERT INTO sys_city VALUES ('130903', '运河区', '130900'); INSERT INTO sys_city VALUES ('130921', '沧县', '130900'); INSERT INTO sys_city VALUES ('130922', '青县', '130900'); INSERT INTO sys_city VALUES ('130923', '东光县', '130900'); INSERT INTO sys_city VALUES ('130924', '海兴县', '130900'); INSERT INTO sys_city VALUES ('130925', '盐山县', '130900'); INSERT INTO sys_city VALUES ('130926', '肃宁县', '130900'); INSERT INTO sys_city VALUES ('130927', '南皮县', '130900'); INSERT INTO sys_city VALUES ('130928', '吴桥县', '130900'); INSERT INTO sys_city VALUES ('130929', '献县', '130900'); INSERT INTO sys_city VALUES ('130930', '孟村回族自治县', '130900'); INSERT INTO sys_city VALUES ('130981', '泊头市', '130900'); INSERT INTO sys_city VALUES ('130982', '任丘市', '130900'); INSERT INTO sys_city VALUES ('130983', '黄骅市', '130900'); INSERT INTO sys_city VALUES ('130984', '河间市', '130900'); INSERT INTO sys_city VALUES ('131000', '廊坊市', '130000'); INSERT INTO sys_city VALUES ('131002', '安次区', '131000'); INSERT INTO sys_city VALUES ('131003', '广阳区', '131000'); INSERT INTO sys_city VALUES ('131022', '固安县', '131000'); INSERT INTO sys_city VALUES ('131023', '永清县', '131000'); INSERT INTO sys_city VALUES ('131024', '香河县', '131000'); INSERT INTO sys_city VALUES ('131025', '大城县', '131000'); INSERT INTO sys_city VALUES ('131026', '文安县', '131000'); INSERT INTO sys_city VALUES ('131028', '大厂回族自治县', '131000'); INSERT INTO sys_city VALUES ('131081', '霸州市', '131000'); INSERT INTO sys_city VALUES ('131082', '三河市', '131000'); INSERT INTO sys_city VALUES ('131100', '衡水市', '130000'); INSERT INTO sys_city VALUES ('131102', '桃城区', '131100'); INSERT INTO sys_city VALUES ('131121', '枣强县', '131100'); INSERT INTO sys_city VALUES ('131122', '武邑县', '131100'); INSERT INTO sys_city VALUES ('131123', '武强县', '131100'); INSERT INTO sys_city VALUES ('131124', '饶阳县', '131100'); INSERT INTO sys_city VALUES ('131125', '安平县', '131100'); INSERT INTO sys_city VALUES ('131126', '故城县', '131100'); INSERT INTO sys_city VALUES ('131127', '景县', '131100'); INSERT INTO sys_city VALUES ('131128', '阜城县', '131100'); INSERT INTO sys_city VALUES ('131181', '冀州市', '131100'); INSERT INTO sys_city VALUES ('131182', '深州市', '131100'); INSERT INTO sys_city VALUES ('140000', '山西省', '0'); INSERT INTO sys_city VALUES ('140100', '太原市', '140000'); INSERT INTO sys_city VALUES ('140105', '小店区', '140100'); INSERT INTO sys_city VALUES ('140106', '迎泽区', '140100'); INSERT INTO sys_city VALUES ('140107', '杏花岭区', '140100'); INSERT INTO sys_city VALUES ('140108', '尖草坪区', '140100'); INSERT INTO sys_city VALUES ('140109', '万柏林区', '140100'); INSERT INTO sys_city VALUES ('140110', '晋源区', '140100'); INSERT INTO sys_city VALUES ('140121', '清徐县', '140100'); INSERT INTO sys_city VALUES ('140122', '阳曲县', '140100'); INSERT INTO sys_city VALUES ('140123', '娄烦县', '140100'); INSERT INTO sys_city VALUES ('140181', '古交市', '140100'); INSERT INTO sys_city VALUES ('140200', '大同市', '140000'); INSERT INTO sys_city VALUES ('140202', '城区', '140200'); INSERT INTO sys_city VALUES ('140203', '矿区', '140200'); INSERT INTO sys_city VALUES ('140211', '南郊区', '140200'); INSERT INTO sys_city VALUES ('140212', '新荣区', '140200'); INSERT INTO sys_city VALUES ('140221', '阳高县', '140200'); INSERT INTO sys_city VALUES ('140222', '天镇县', '140200'); INSERT INTO sys_city VALUES ('140223', '广灵县', '140200'); INSERT INTO sys_city VALUES ('140224', '灵丘县', '140200'); INSERT INTO sys_city VALUES ('140225', '浑源县', '140200'); INSERT INTO sys_city VALUES ('140226', '左云县', '140200'); INSERT INTO sys_city VALUES ('140227', '大同县', '140200'); INSERT INTO sys_city VALUES ('140300', '阳泉市', '140000'); INSERT INTO sys_city VALUES ('140302', '城区', '140300'); INSERT INTO sys_city VALUES ('140303', '矿区', '140300'); INSERT INTO sys_city VALUES ('140311', '郊区', '140300'); INSERT INTO sys_city VALUES ('140321', '平定县', '140300'); INSERT INTO sys_city VALUES ('140322', '盂县', '140300'); INSERT INTO sys_city VALUES ('140400', '长治市', '140000'); INSERT INTO sys_city VALUES ('140402', '城区', '140400'); INSERT INTO sys_city VALUES ('140411', '郊区', '140400'); INSERT INTO sys_city VALUES ('140421', '长治县', '140400'); INSERT INTO sys_city VALUES ('140423', '襄垣县', '140400'); INSERT INTO sys_city VALUES ('140424', '屯留县', '140400'); INSERT INTO sys_city VALUES ('140425', '平顺县', '140400'); INSERT INTO sys_city VALUES ('140426', '黎城县', '140400'); INSERT INTO sys_city VALUES ('140427', '壶关县', '140400'); INSERT INTO sys_city VALUES ('140428', '长子县', '140400'); INSERT INTO sys_city VALUES ('140429', '武乡县', '140400'); INSERT INTO sys_city VALUES ('140430', '沁县', '140400'); INSERT INTO sys_city VALUES ('140431', '沁源县', '140400'); INSERT INTO sys_city VALUES ('140481', '潞城市', '140400'); INSERT INTO sys_city VALUES ('140500', '晋城市', '140000'); INSERT INTO sys_city VALUES ('140502', '城区', '140500'); INSERT INTO sys_city VALUES ('140521', '沁水县', '140500'); INSERT INTO sys_city VALUES ('140522', '阳城县', '140500'); INSERT INTO sys_city VALUES ('140524', '陵川县', '140500'); INSERT INTO sys_city VALUES ('140525', '泽州县', '140500'); INSERT INTO sys_city VALUES ('140581', '高平市', '140500'); INSERT INTO sys_city VALUES ('140600', '朔州市', '140000'); INSERT INTO sys_city VALUES ('140602', '朔城区', '140600'); INSERT INTO sys_city VALUES ('140603', '平鲁区', '140600'); INSERT INTO sys_city VALUES ('140621', '山阴县', '140600'); INSERT INTO sys_city VALUES ('140622', '应县', '140600'); INSERT INTO sys_city VALUES ('140623', '右玉县', '140600'); INSERT INTO sys_city VALUES ('140624', '怀仁县', '140600'); INSERT INTO sys_city VALUES ('140700', '晋中市', '140000'); INSERT INTO sys_city VALUES ('140702', '榆次区', '140700'); INSERT INTO sys_city VALUES ('140721', '榆社县', '140700'); INSERT INTO sys_city VALUES ('140722', '左权县', '140700'); INSERT INTO sys_city VALUES ('140723', '和顺县', '140700'); INSERT INTO sys_city VALUES ('140724', '昔阳县', '140700'); INSERT INTO sys_city VALUES ('140725', '寿阳县', '140700'); INSERT INTO sys_city VALUES ('140726', '太谷县', '140700'); INSERT INTO sys_city VALUES ('140727', '祁县', '140700'); INSERT INTO sys_city VALUES ('140728', '平遥县', '140700'); INSERT INTO sys_city VALUES ('140729', '灵石县', '140700'); INSERT INTO sys_city VALUES ('140781', '介休市', '140700'); INSERT INTO sys_city VALUES ('140800', '运城市', '140000'); INSERT INTO sys_city VALUES ('140802', '盐湖区', '140800'); INSERT INTO sys_city VALUES ('140821', '临猗县', '140800'); INSERT INTO sys_city VALUES ('140822', '万荣县', '140800'); INSERT INTO sys_city VALUES ('140823', '闻喜县', '140800'); INSERT INTO sys_city VALUES ('140824', '稷山县', '140800'); INSERT INTO sys_city VALUES ('140825', '新绛县', '140800'); INSERT INTO sys_city VALUES ('140826', '绛县', '140800'); INSERT INTO sys_city VALUES ('140827', '垣曲县', '140800'); INSERT INTO sys_city VALUES ('140828', '夏县', '140800'); INSERT INTO sys_city VALUES ('140829', '平陆县', '140800'); INSERT INTO sys_city VALUES ('140830', '芮城县', '140800'); INSERT INTO sys_city VALUES ('140881', '永济市', '140800'); INSERT INTO sys_city VALUES ('140882', '河津市', '140800'); INSERT INTO sys_city VALUES ('140900', '忻州市', '140000'); INSERT INTO sys_city VALUES ('140902', '忻府区', '140900'); INSERT INTO sys_city VALUES ('140921', '定襄县', '140900'); INSERT INTO sys_city VALUES ('140922', '五台县', '140900'); INSERT INTO sys_city VALUES ('140923', '代县', '140900'); INSERT INTO sys_city VALUES ('140924', '繁峙县', '140900'); INSERT INTO sys_city VALUES ('140925', '宁武县', '140900'); INSERT INTO sys_city VALUES ('140926', '静乐县', '140900'); INSERT INTO sys_city VALUES ('140927', '神池县', '140900'); INSERT INTO sys_city VALUES ('140928', '五寨县', '140900'); INSERT INTO sys_city VALUES ('140929', '岢岚县', '140900'); INSERT INTO sys_city VALUES ('140930', '河曲县', '140900'); INSERT INTO sys_city VALUES ('140931', '保德县', '140900'); INSERT INTO sys_city VALUES ('140932', '偏关县', '140900'); INSERT INTO sys_city VALUES ('140981', '原平市', '140900'); INSERT INTO sys_city VALUES ('141000', '临汾市', '140000'); INSERT INTO sys_city VALUES ('141002', '尧都区', '141000'); INSERT INTO sys_city VALUES ('141021', '曲沃县', '141000'); INSERT INTO sys_city VALUES ('141022', '翼城县', '141000'); INSERT INTO sys_city VALUES ('141023', '襄汾县', '141000'); INSERT INTO sys_city VALUES ('141024', '洪洞县', '141000'); INSERT INTO sys_city VALUES ('141025', '古县', '141000'); INSERT INTO sys_city VALUES ('141026', '安泽县', '141000'); INSERT INTO sys_city VALUES ('141027', '浮山县', '141000'); INSERT INTO sys_city VALUES ('141028', '吉县', '141000'); INSERT INTO sys_city VALUES ('141029', '乡宁县', '141000'); INSERT INTO sys_city VALUES ('141030', '大宁县', '141000'); INSERT INTO sys_city VALUES ('141031', '隰县', '141000'); INSERT INTO sys_city VALUES ('141032', '永和县', '141000'); INSERT INTO sys_city VALUES ('141033', '蒲县', '141000'); INSERT INTO sys_city VALUES ('141034', '汾西县', '141000'); INSERT INTO sys_city VALUES ('141081', '侯马市', '141000'); INSERT INTO sys_city VALUES ('141082', '霍州市', '141000'); INSERT INTO sys_city VALUES ('141100', '吕梁市', '140000'); INSERT INTO sys_city VALUES ('141102', '离石区', '141100'); INSERT INTO sys_city VALUES ('141121', '文水县', '141100'); INSERT INTO sys_city VALUES ('141122', '交城县', '141100'); INSERT INTO sys_city VALUES ('141123', '兴县', '141100'); INSERT INTO sys_city VALUES ('141124', '临县', '141100'); INSERT INTO sys_city VALUES ('141125', '柳林县', '141100'); INSERT INTO sys_city VALUES ('141126', '石楼县', '141100'); INSERT INTO sys_city VALUES ('141127', '岚县', '141100'); INSERT INTO sys_city VALUES ('141128', '方山县', '141100'); INSERT INTO sys_city VALUES ('141129', '中阳县', '141100'); INSERT INTO sys_city VALUES ('141130', '交口县', '141100'); INSERT INTO sys_city VALUES ('141181', '孝义市', '141100'); INSERT INTO sys_city VALUES ('141182', '汾阳市', '141100'); INSERT INTO sys_city VALUES ('150000', '内蒙古自治区', '0'); INSERT INTO sys_city VALUES ('150100', '呼和浩特市', '150000'); INSERT INTO sys_city VALUES ('150102', '新城区', '150100'); INSERT INTO sys_city VALUES ('150103', '回民区', '150100'); INSERT INTO sys_city VALUES ('150104', '玉泉区', '150100'); INSERT INTO sys_city VALUES ('150105', '赛罕区', '150100'); INSERT INTO sys_city VALUES ('150121', '土默特左旗', '150100'); INSERT INTO sys_city VALUES ('150122', '托克托县', '150100'); INSERT INTO sys_city VALUES ('150123', '和林格尔县', '150100'); INSERT INTO sys_city VALUES ('150124', '清水河县', '150100'); INSERT INTO sys_city VALUES ('150125', '武川县', '150100'); INSERT INTO sys_city VALUES ('150200', '包头市', '150000'); INSERT INTO sys_city VALUES ('150202', '东河区', '150200'); INSERT INTO sys_city VALUES ('150203', '昆都仑区', '150200'); INSERT INTO sys_city VALUES ('150204', '青山区', '150200'); INSERT INTO sys_city VALUES ('150205', '石拐区', '150200'); INSERT INTO sys_city VALUES ('150206', '白云鄂博矿区', '150200'); INSERT INTO sys_city VALUES ('150207', '九原区', '150200'); INSERT INTO sys_city VALUES ('150221', '土默特右旗', '150200'); INSERT INTO sys_city VALUES ('150222', '固阳县', '150200'); INSERT INTO sys_city VALUES ('150223', '达尔罕茂明安联合旗', '150200'); INSERT INTO sys_city VALUES ('150300', '乌海市', '150000'); INSERT INTO sys_city VALUES ('150302', '海勃湾区', '150300'); INSERT INTO sys_city VALUES ('150303', '海南区', '150300'); INSERT INTO sys_city VALUES ('150304', '乌达区', '150300'); INSERT INTO sys_city VALUES ('150400', '赤峰市', '150000'); INSERT INTO sys_city VALUES ('150402', '红山区', '150400'); INSERT INTO sys_city VALUES ('150403', '元宝山区', '150400'); INSERT INTO sys_city VALUES ('150404', '松山区', '150400'); INSERT INTO sys_city VALUES ('150421', '阿鲁科尔沁旗', '150400'); INSERT INTO sys_city VALUES ('150422', '巴林左旗', '150400'); INSERT INTO sys_city VALUES ('150423', '巴林右旗', '150400'); INSERT INTO sys_city VALUES ('150424', '林西县', '150400'); INSERT INTO sys_city VALUES ('150425', '克什克腾旗', '150400'); INSERT INTO sys_city VALUES ('150426', '翁牛特旗', '150400'); INSERT INTO sys_city VALUES ('150428', '喀喇沁旗', '150400'); INSERT INTO sys_city VALUES ('150429', '宁城县', '150400'); INSERT INTO sys_city VALUES ('150430', '敖汉旗', '150400'); INSERT INTO sys_city VALUES ('150500', '通辽市', '150000'); INSERT INTO sys_city VALUES ('150502', '科尔沁区', '150500'); INSERT INTO sys_city VALUES ('150521', '科尔沁左翼中旗', '150500'); INSERT INTO sys_city VALUES ('150522', '科尔沁左翼后旗', '150500'); INSERT INTO sys_city VALUES ('150523', '开鲁县', '150500'); INSERT INTO sys_city VALUES ('150524', '库伦旗', '150500'); INSERT INTO sys_city VALUES ('150525', '奈曼旗', '150500'); INSERT INTO sys_city VALUES ('150526', '扎鲁特旗', '150500'); INSERT INTO sys_city VALUES ('150581', '霍林郭勒市', '150500'); INSERT INTO sys_city VALUES ('150600', '鄂尔多斯市', '150000'); INSERT INTO sys_city VALUES ('150602', '东胜区', '150600'); INSERT INTO sys_city VALUES ('150621', '达拉特旗', '150600'); INSERT INTO sys_city VALUES ('150622', '准格尔旗', '150600'); INSERT INTO sys_city VALUES ('150623', '鄂托克前旗', '150600'); INSERT INTO sys_city VALUES ('150624', '鄂托克旗', '150600'); INSERT INTO sys_city VALUES ('150625', '杭锦旗', '150600'); INSERT INTO sys_city VALUES ('150626', '乌审旗', '150600'); INSERT INTO sys_city VALUES ('150627', '伊金霍洛旗', '150600'); INSERT INTO sys_city VALUES ('150700', '呼伦贝尔市', '150000'); INSERT INTO sys_city VALUES ('150702', '海拉尔区', '150700'); INSERT INTO sys_city VALUES ('150703', '扎赉诺尔区', '150700'); INSERT INTO sys_city VALUES ('150721', '阿荣旗', '150700'); INSERT INTO sys_city VALUES ('150722', '莫力达瓦达斡尔族自治旗', '150700'); INSERT INTO sys_city VALUES ('150723', '鄂伦春自治旗', '150700'); INSERT INTO sys_city VALUES ('150724', '鄂温克族自治旗', '150700'); INSERT INTO sys_city VALUES ('150725', '陈巴尔虎旗', '150700'); INSERT INTO sys_city VALUES ('150726', '新巴尔虎左旗', '150700'); INSERT INTO sys_city VALUES ('150727', '新巴尔虎右旗', '150700'); INSERT INTO sys_city VALUES ('150781', '满洲里市', '150700'); INSERT INTO sys_city VALUES ('150782', '牙克石市', '150700'); INSERT INTO sys_city VALUES ('150783', '扎兰屯市', '150700'); INSERT INTO sys_city VALUES ('150784', '额尔古纳市', '150700'); INSERT INTO sys_city VALUES ('150785', '根河市', '150700'); INSERT INTO sys_city VALUES ('150800', '巴彦淖尔市', '150000'); INSERT INTO sys_city VALUES ('150802', '临河区', '150800'); INSERT INTO sys_city VALUES ('150821', '五原县', '150800'); INSERT INTO sys_city VALUES ('150822', '磴口县', '150800'); INSERT INTO sys_city VALUES ('150823', '乌拉特前旗', '150800'); INSERT INTO sys_city VALUES ('150824', '乌拉特中旗', '150800'); INSERT INTO sys_city VALUES ('150825', '乌拉特后旗', '150800'); INSERT INTO sys_city VALUES ('150826', '杭锦后旗', '150800'); INSERT INTO sys_city VALUES ('150900', '乌兰察布市', '150000'); INSERT INTO sys_city VALUES ('150902', '集宁区', '150900'); INSERT INTO sys_city VALUES ('150921', '卓资县', '150900'); INSERT INTO sys_city VALUES ('150922', '化德县', '150900'); INSERT INTO sys_city VALUES ('150923', '商都县', '150900'); INSERT INTO sys_city VALUES ('150924', '兴和县', '150900'); INSERT INTO sys_city VALUES ('150925', '凉城县', '150900'); INSERT INTO sys_city VALUES ('150926', '察哈尔右翼前旗', '150900'); INSERT INTO sys_city VALUES ('150927', '察哈尔右翼中旗', '150900'); INSERT INTO sys_city VALUES ('150928', '察哈尔右翼后旗', '150900'); INSERT INTO sys_city VALUES ('150929', '四子王旗', '150900'); INSERT INTO sys_city VALUES ('150981', '丰镇市', '150900'); INSERT INTO sys_city VALUES ('152200', '兴安盟', '150000'); INSERT INTO sys_city VALUES ('152201', '乌兰浩特市', '152200'); INSERT INTO sys_city VALUES ('152202', '阿尔山市', '152200'); INSERT INTO sys_city VALUES ('152221', '科尔沁右翼前旗', '152200'); INSERT INTO sys_city VALUES ('152222', '科尔沁右翼中旗', '152200'); INSERT INTO sys_city VALUES ('152223', '扎赉特旗', '152200'); INSERT INTO sys_city VALUES ('152224', '突泉县', '152200'); INSERT INTO sys_city VALUES ('152500', '锡林郭勒盟', '150000'); INSERT INTO sys_city VALUES ('152501', '二连浩特市', '152500'); INSERT INTO sys_city VALUES ('152502', '锡林浩特市', '152500'); INSERT INTO sys_city VALUES ('152522', '阿巴嘎旗', '152500'); INSERT INTO sys_city VALUES ('152523', '苏尼特左旗', '152500'); INSERT INTO sys_city VALUES ('152524', '苏尼特右旗', '152500'); INSERT INTO sys_city VALUES ('152525', '东乌珠穆沁旗', '152500'); INSERT INTO sys_city VALUES ('152526', '西乌珠穆沁旗', '152500'); INSERT INTO sys_city VALUES ('152527', '太仆寺旗', '152500'); INSERT INTO sys_city VALUES ('152528', '镶黄旗', '152500'); INSERT INTO sys_city VALUES ('152529', '正镶白旗', '152500'); INSERT INTO sys_city VALUES ('152530', '正蓝旗', '152500'); INSERT INTO sys_city VALUES ('152531', '多伦县', '152500'); INSERT INTO sys_city VALUES ('152900', '阿拉善盟', '150000'); INSERT INTO sys_city VALUES ('152921', '阿拉善左旗', '152900'); INSERT INTO sys_city VALUES ('152922', '阿拉善右旗', '152900'); INSERT INTO sys_city VALUES ('152923', '额济纳旗', '152900'); INSERT INTO sys_city VALUES ('210000', '辽宁省', '0'); INSERT INTO sys_city VALUES ('210100', '沈阳市', '210000'); INSERT INTO sys_city VALUES ('210102', '和平区', '210100'); INSERT INTO sys_city VALUES ('210103', '沈河区', '210100'); INSERT INTO sys_city VALUES ('210104', '大东区', '210100'); INSERT INTO sys_city VALUES ('210105', '皇姑区', '210100'); INSERT INTO sys_city VALUES ('210106', '铁西区', '210100'); INSERT INTO sys_city VALUES ('210111', '苏家屯区', '210100'); INSERT INTO sys_city VALUES ('210112', '东陵区', '210100'); INSERT INTO sys_city VALUES ('210113', '沈北新区', '210100'); INSERT INTO sys_city VALUES ('210114', '于洪区', '210100'); INSERT INTO sys_city VALUES ('210122', '辽中县', '210100'); INSERT INTO sys_city VALUES ('210123', '康平县', '210100'); INSERT INTO sys_city VALUES ('210124', '法库县', '210100'); INSERT INTO sys_city VALUES ('210181', '新民市', '210100'); INSERT INTO sys_city VALUES ('210200', '大连市', '210000'); INSERT INTO sys_city VALUES ('210202', '中山区', '210200'); INSERT INTO sys_city VALUES ('210203', '西岗区', '210200'); INSERT INTO sys_city VALUES ('210204', '沙河口区', '210200'); INSERT INTO sys_city VALUES ('210211', '甘井子区', '210200'); INSERT INTO sys_city VALUES ('210212', '旅顺口区', '210200'); INSERT INTO sys_city VALUES ('210213', '金州区', '210200'); INSERT INTO sys_city VALUES ('210224', '长海县', '210200'); INSERT INTO sys_city VALUES ('210281', '瓦房店市', '210200'); INSERT INTO sys_city VALUES ('210282', '普兰店市', '210200'); INSERT INTO sys_city VALUES ('210283', '庄河市', '210200'); INSERT INTO sys_city VALUES ('210300', '鞍山市', '210000'); INSERT INTO sys_city VALUES ('210302', '铁东区', '210300'); INSERT INTO sys_city VALUES ('210303', '铁西区', '210300'); INSERT INTO sys_city VALUES ('210304', '立山区', '210300'); INSERT INTO sys_city VALUES ('210311', '千山区', '210300'); INSERT INTO sys_city VALUES ('210321', '台安县', '210300'); INSERT INTO sys_city VALUES ('210323', '岫岩满族自治县', '210300'); INSERT INTO sys_city VALUES ('210381', '海城市', '210300'); INSERT INTO sys_city VALUES ('210400', '抚顺市', '210000'); INSERT INTO sys_city VALUES ('210402', '新抚区', '210400'); INSERT INTO sys_city VALUES ('210403', '东洲区', '210400'); INSERT INTO sys_city VALUES ('210404', '望花区', '210400'); INSERT INTO sys_city VALUES ('210411', '顺城区', '210400'); INSERT INTO sys_city VALUES ('210421', '抚顺县', '210400'); INSERT INTO sys_city VALUES ('210422', '新宾满族自治县', '210400'); INSERT INTO sys_city VALUES ('210423', '清原满族自治县', '210400'); INSERT INTO sys_city VALUES ('210500', '本溪市', '210000'); INSERT INTO sys_city VALUES ('210502', '平山区', '210500'); INSERT INTO sys_city VALUES ('210503', '溪湖区', '210500'); INSERT INTO sys_city VALUES ('210504', '明山区', '210500'); INSERT INTO sys_city VALUES ('210505', '南芬区', '210500'); INSERT INTO sys_city VALUES ('210521', '本溪满族自治县', '210500'); INSERT INTO sys_city VALUES ('210522', '桓仁满族自治县', '210500'); INSERT INTO sys_city VALUES ('210600', '丹东市', '210000'); INSERT INTO sys_city VALUES ('210602', '元宝区', '210600'); INSERT INTO sys_city VALUES ('210603', '振兴区', '210600'); INSERT INTO sys_city VALUES ('210604', '振安区', '210600'); INSERT INTO sys_city VALUES ('210624', '宽甸满族自治县', '210600'); INSERT INTO sys_city VALUES ('210681', '东港市', '210600'); INSERT INTO sys_city VALUES ('210682', '凤城市', '210600'); INSERT INTO sys_city VALUES ('210700', '锦州市', '210000'); INSERT INTO sys_city VALUES ('210702', '古塔区', '210700'); INSERT INTO sys_city VALUES ('210703', '凌河区', '210700'); INSERT INTO sys_city VALUES ('210711', '太和区', '210700'); INSERT INTO sys_city VALUES ('210726', '黑山县', '210700'); INSERT INTO sys_city VALUES ('210727', '义县', '210700'); INSERT INTO sys_city VALUES ('210781', '凌海市', '210700'); INSERT INTO sys_city VALUES ('210782', '北镇市', '210700'); INSERT INTO sys_city VALUES ('210800', '营口市', '210000'); INSERT INTO sys_city VALUES ('210802', '站前区', '210800'); INSERT INTO sys_city VALUES ('210803', '西市区', '210800'); INSERT INTO sys_city VALUES ('210804', '鲅鱼圈区', '210800'); INSERT INTO sys_city VALUES ('210811', '老边区', '210800'); INSERT INTO sys_city VALUES ('210881', '盖州市', '210800'); INSERT INTO sys_city VALUES ('210882', '大石桥市', '210800'); INSERT INTO sys_city VALUES ('210900', '阜新市', '210000'); INSERT INTO sys_city VALUES ('210902', '海州区', '210900'); INSERT INTO sys_city VALUES ('210903', '新邱区', '210900'); INSERT INTO sys_city VALUES ('210904', '太平区', '210900'); INSERT INTO sys_city VALUES ('210905', '清河门区', '210900'); INSERT INTO sys_city VALUES ('210911', '细河区', '210900'); INSERT INTO sys_city VALUES ('210921', '阜新蒙古族自治县', '210900'); INSERT INTO sys_city VALUES ('210922', '彰武县', '210900'); INSERT INTO sys_city VALUES ('211000', '辽阳市', '210000'); INSERT INTO sys_city VALUES ('211002', '白塔区', '211000'); INSERT INTO sys_city VALUES ('211003', '文圣区', '211000'); INSERT INTO sys_city VALUES ('211004', '宏伟区', '211000'); INSERT INTO sys_city VALUES ('211005', '弓长岭区', '211000'); INSERT INTO sys_city VALUES ('211011', '太子河区', '211000'); INSERT INTO sys_city VALUES ('211021', '辽阳县', '211000'); INSERT INTO sys_city VALUES ('211081', '灯塔市', '211000'); INSERT INTO sys_city VALUES ('211100', '盘锦市', '210000'); INSERT INTO sys_city VALUES ('211102', '双台子区', '211100'); INSERT INTO sys_city VALUES ('211103', '兴隆台区', '211100'); INSERT INTO sys_city VALUES ('211121', '大洼县', '211100'); INSERT INTO sys_city VALUES ('211122', '盘山县', '211100'); INSERT INTO sys_city VALUES ('211200', '铁岭市', '210000'); INSERT INTO sys_city VALUES ('211202', '银州区', '211200'); INSERT INTO sys_city VALUES ('211204', '清河区', '211200'); INSERT INTO sys_city VALUES ('211221', '铁岭县', '211200'); INSERT INTO sys_city VALUES ('211223', '西丰县', '211200'); INSERT INTO sys_city VALUES ('211224', '昌图县', '211200'); INSERT INTO sys_city VALUES ('211281', '调兵山市', '211200'); INSERT INTO sys_city VALUES ('211282', '开原市', '211200'); INSERT INTO sys_city VALUES ('211300', '朝阳市', '210000'); INSERT INTO sys_city VALUES ('211302', '双塔区', '211300'); INSERT INTO sys_city VALUES ('211303', '龙城区', '211300'); INSERT INTO sys_city VALUES ('211321', '朝阳县', '211300'); INSERT INTO sys_city VALUES ('211322', '建平县', '211300'); INSERT INTO sys_city VALUES ('211324', '喀喇沁左翼蒙古族自治县', '211300'); INSERT INTO sys_city VALUES ('211381', '北票市', '211300'); INSERT INTO sys_city VALUES ('211382', '凌源市', '211300'); INSERT INTO sys_city VALUES ('211400', '葫芦岛市', '210000'); INSERT INTO sys_city VALUES ('211402', '连山区', '211400'); INSERT INTO sys_city VALUES ('211403', '龙港区', '211400'); INSERT INTO sys_city VALUES ('211404', '南票区', '211400'); INSERT INTO sys_city VALUES ('211421', '绥中县', '211400'); INSERT INTO sys_city VALUES ('211422', '建昌县', '211400'); INSERT INTO sys_city VALUES ('211481', '兴城市', '211400'); INSERT INTO sys_city VALUES ('220000', '吉林省', '0'); INSERT INTO sys_city VALUES ('220100', '长春市', '220000'); INSERT INTO sys_city VALUES ('220102', '南关区', '220100'); INSERT INTO sys_city VALUES ('220103', '宽城区', '220100'); INSERT INTO sys_city VALUES ('220104', '朝阳区', '220100'); INSERT INTO sys_city VALUES ('220105', '二道区', '220100'); INSERT INTO sys_city VALUES ('220106', '绿园区', '220100'); INSERT INTO sys_city VALUES ('220112', '双阳区', '220100'); INSERT INTO sys_city VALUES ('220113', '九台区', '220100'); INSERT INTO sys_city VALUES ('220122', '农安县', '220100'); INSERT INTO sys_city VALUES ('220182', '榆树市', '220100'); INSERT INTO sys_city VALUES ('220183', '德惠市', '220100'); INSERT INTO sys_city VALUES ('220200', '吉林市', '220000'); INSERT INTO sys_city VALUES ('220202', '昌邑区', '220200'); INSERT INTO sys_city VALUES ('220203', '龙潭区', '220200'); INSERT INTO sys_city VALUES ('220204', '船营区', '220200'); INSERT INTO sys_city VALUES ('220211', '丰满区', '220200'); INSERT INTO sys_city VALUES ('220221', '永吉县', '220200'); INSERT INTO sys_city VALUES ('220281', '蛟河市', '220200'); INSERT INTO sys_city VALUES ('220282', '桦甸市', '220200'); INSERT INTO sys_city VALUES ('220283', '舒兰市', '220200'); INSERT INTO sys_city VALUES ('220284', '磐石市', '220200'); INSERT INTO sys_city VALUES ('220300', '四平市', '220000'); INSERT INTO sys_city VALUES ('220302', '铁西区', '220300'); INSERT INTO sys_city VALUES ('220303', '铁东区', '220300'); INSERT INTO sys_city VALUES ('220322', '梨树县', '220300'); INSERT INTO sys_city VALUES ('220323', '伊通满族自治县', '220300'); INSERT INTO sys_city VALUES ('220381', '公主岭市', '220300'); INSERT INTO sys_city VALUES ('220382', '双辽市', '220300'); INSERT INTO sys_city VALUES ('220400', '辽源市', '220000'); INSERT INTO sys_city VALUES ('220402', '龙山区', '220400'); INSERT INTO sys_city VALUES ('220403', '西安区', '220400'); INSERT INTO sys_city VALUES ('220421', '东丰县', '220400'); INSERT INTO sys_city VALUES ('220422', '东辽县', '220400'); INSERT INTO sys_city VALUES ('220500', '通化市', '220000'); INSERT INTO sys_city VALUES ('220502', '东昌区', '220500'); INSERT INTO sys_city VALUES ('220503', '二道江区', '220500'); INSERT INTO sys_city VALUES ('220521', '通化县', '220500'); INSERT INTO sys_city VALUES ('220523', '辉南县', '220500'); INSERT INTO sys_city VALUES ('220524', '柳河县', '220500'); INSERT INTO sys_city VALUES ('220581', '梅河口市', '220500'); INSERT INTO sys_city VALUES ('220582', '集安市', '220500'); INSERT INTO sys_city VALUES ('220600', '白山市', '220000'); INSERT INTO sys_city VALUES ('220602', '浑江区', '220600'); INSERT INTO sys_city VALUES ('220605', '江源区', '220600'); INSERT INTO sys_city VALUES ('220621', '抚松县', '220600'); INSERT INTO sys_city VALUES ('220622', '靖宇县', '220600'); INSERT INTO sys_city VALUES ('220623', '长白朝鲜族自治县', '220600'); INSERT INTO sys_city VALUES ('220681', '临江市', '220600'); INSERT INTO sys_city VALUES ('220700', '松原市', '220000'); INSERT INTO sys_city VALUES ('220702', '宁江区', '220700'); INSERT INTO sys_city VALUES ('220721', '前郭尔罗斯蒙古族自治县', '220700'); INSERT INTO sys_city VALUES ('220722', '长岭县', '220700'); INSERT INTO sys_city VALUES ('220723', '乾安县', '220700'); INSERT INTO sys_city VALUES ('220781', '扶余市', '220700'); INSERT INTO sys_city VALUES ('220800', '白城市', '220000'); INSERT INTO sys_city VALUES ('220802', '洮北区', '220800'); INSERT INTO sys_city VALUES ('220821', '镇赉县', '220800'); INSERT INTO sys_city VALUES ('220822', '通榆县', '220800'); INSERT INTO sys_city VALUES ('220881', '洮南市', '220800'); INSERT INTO sys_city VALUES ('220882', '大安市', '220800'); INSERT INTO sys_city VALUES ('222400', '延边朝鲜族自治州', '220000'); INSERT INTO sys_city VALUES ('222401', '延吉市', '222400'); INSERT INTO sys_city VALUES ('222402', '图们市', '222400'); INSERT INTO sys_city VALUES ('222403', '敦化市', '222400'); INSERT INTO sys_city VALUES ('222404', '珲春市', '222400'); INSERT INTO sys_city VALUES ('222405', '龙井市', '222400'); INSERT INTO sys_city VALUES ('222406', '和龙市', '222400'); INSERT INTO sys_city VALUES ('222424', '汪清县', '222400'); INSERT INTO sys_city VALUES ('222426', '安图县', '222400'); INSERT INTO sys_city VALUES ('230000', '黑龙江省', '0'); INSERT INTO sys_city VALUES ('230100', '哈尔滨市', '230000'); INSERT INTO sys_city VALUES ('230102', '道里区', '230100'); INSERT INTO sys_city VALUES ('230103', '南岗区', '230100'); INSERT INTO sys_city VALUES ('230104', '道外区', '230100'); INSERT INTO sys_city VALUES ('230108', '平房区', '230100'); INSERT INTO sys_city VALUES ('230109', '松北区', '230100'); INSERT INTO sys_city VALUES ('230110', '香坊区', '230100'); INSERT INTO sys_city VALUES ('230111', '呼兰区', '230100'); INSERT INTO sys_city VALUES ('230112', '阿城区', '230100'); INSERT INTO sys_city VALUES ('230113', '双城区', '230100'); INSERT INTO sys_city VALUES ('230123', '依兰县', '230100'); INSERT INTO sys_city VALUES ('230124', '方正县', '230100'); INSERT INTO sys_city VALUES ('230125', '宾县', '230100'); INSERT INTO sys_city VALUES ('230126', '巴彦县', '230100'); INSERT INTO sys_city VALUES ('230127', '木兰县', '230100'); INSERT INTO sys_city VALUES ('230128', '通河县', '230100'); INSERT INTO sys_city VALUES ('230129', '延寿县', '230100'); INSERT INTO sys_city VALUES ('230183', '尚志市', '230100'); INSERT INTO sys_city VALUES ('230184', '五常市', '230100'); INSERT INTO sys_city VALUES ('230200', '齐齐哈尔市', '230000'); INSERT INTO sys_city VALUES ('230202', '龙沙区', '230200'); INSERT INTO sys_city VALUES ('230203', '建华区', '230200'); INSERT INTO sys_city VALUES ('230204', '铁锋区', '230200'); INSERT INTO sys_city VALUES ('230205', '昂昂溪区', '230200'); INSERT INTO sys_city VALUES ('230206', '富拉尔基区', '230200'); INSERT INTO sys_city VALUES ('230207', '碾子山区', '230200'); INSERT INTO sys_city VALUES ('230208', '梅里斯达斡尔族区', '230200'); INSERT INTO sys_city VALUES ('230221', '龙江县', '230200'); INSERT INTO sys_city VALUES ('230223', '依安县', '230200'); INSERT INTO sys_city VALUES ('230224', '泰来县', '230200'); INSERT INTO sys_city VALUES ('230225', '甘南县', '230200'); INSERT INTO sys_city VALUES ('230227', '富裕县', '230200'); INSERT INTO sys_city VALUES ('230229', '克山县', '230200'); INSERT INTO sys_city VALUES ('230230', '克东县', '230200'); INSERT INTO sys_city VALUES ('230231', '拜泉县', '230200'); INSERT INTO sys_city VALUES ('230281', '讷河市', '230200'); INSERT INTO sys_city VALUES ('230300', '鸡西市', '230000'); INSERT INTO sys_city VALUES ('230302', '鸡冠区', '230300'); INSERT INTO sys_city VALUES ('230303', '恒山区', '230300'); INSERT INTO sys_city VALUES ('230304', '滴道区', '230300'); INSERT INTO sys_city VALUES ('230305', '梨树区', '230300'); INSERT INTO sys_city VALUES ('230306', '城子河区', '230300'); INSERT INTO sys_city VALUES ('230307', '麻山区', '230300'); INSERT INTO sys_city VALUES ('230321', '鸡东县', '230300'); INSERT INTO sys_city VALUES ('230381', '虎林市', '230300'); INSERT INTO sys_city VALUES ('230382', '密山市', '230300'); INSERT INTO sys_city VALUES ('230400', '鹤岗市', '230000'); INSERT INTO sys_city VALUES ('230402', '向阳区', '230400'); INSERT INTO sys_city VALUES ('230403', '工农区', '230400'); INSERT INTO sys_city VALUES ('230404', '南山区', '230400'); INSERT INTO sys_city VALUES ('230405', '兴安区', '230400'); INSERT INTO sys_city VALUES ('230406', '东山区', '230400'); INSERT INTO sys_city VALUES ('230407', '兴山区', '230400'); INSERT INTO sys_city VALUES ('230421', '萝北县', '230400'); INSERT INTO sys_city VALUES ('230422', '绥滨县', '230400'); INSERT INTO sys_city VALUES ('230500', '双鸭山市', '230000'); INSERT INTO sys_city VALUES ('230502', '尖山区', '230500'); INSERT INTO sys_city VALUES ('230503', '岭东区', '230500'); INSERT INTO sys_city VALUES ('230505', '四方台区', '230500'); INSERT INTO sys_city VALUES ('230506', '宝山区', '230500'); INSERT INTO sys_city VALUES ('230521', '集贤县', '230500'); INSERT INTO sys_city VALUES ('230522', '友谊县', '230500'); INSERT INTO sys_city VALUES ('230523', '宝清县', '230500'); INSERT INTO sys_city VALUES ('230524', '饶河县', '230500'); INSERT INTO sys_city VALUES ('230600', '大庆市', '230000'); INSERT INTO sys_city VALUES ('230602', '萨尔图区', '230600'); INSERT INTO sys_city VALUES ('230603', '龙凤区', '230600'); INSERT INTO sys_city VALUES ('230604', '让胡路区', '230600'); INSERT INTO sys_city VALUES ('230605', '红岗区', '230600'); INSERT INTO sys_city VALUES ('230606', '大同区', '230600'); INSERT INTO sys_city VALUES ('230621', '肇州县', '230600'); INSERT INTO sys_city VALUES ('230622', '肇源县', '230600'); INSERT INTO sys_city VALUES ('230623', '林甸县', '230600'); INSERT INTO sys_city VALUES ('230624', '杜尔伯特蒙古族自治县', '230600'); INSERT INTO sys_city VALUES ('230700', '伊春市', '230000'); INSERT INTO sys_city VALUES ('230702', '伊春区', '230700'); INSERT INTO sys_city VALUES ('230703', '南岔区', '230700'); INSERT INTO sys_city VALUES ('230704', '友好区', '230700'); INSERT INTO sys_city VALUES ('230705', '西林区', '230700'); INSERT INTO sys_city VALUES ('230706', '翠峦区', '230700'); INSERT INTO sys_city VALUES ('230707', '新青区', '230700'); INSERT INTO sys_city VALUES ('230708', '美溪区', '230700'); INSERT INTO sys_city VALUES ('230709', '金山屯区', '230700'); INSERT INTO sys_city VALUES ('230710', '五营区', '230700'); INSERT INTO sys_city VALUES ('230711', '乌马河区', '230700'); INSERT INTO sys_city VALUES ('230712', '汤旺河区', '230700'); INSERT INTO sys_city VALUES ('230713', '带岭区', '230700'); INSERT INTO sys_city VALUES ('230714', '乌伊岭区', '230700'); INSERT INTO sys_city VALUES ('230715', '红星区', '230700'); INSERT INTO sys_city VALUES ('230716', '上甘岭区', '230700'); INSERT INTO sys_city VALUES ('230722', '嘉荫县', '230700'); INSERT INTO sys_city VALUES ('230781', '铁力市', '230700'); INSERT INTO sys_city VALUES ('230800', '佳木斯市', '230000'); INSERT INTO sys_city VALUES ('230803', '向阳区', '230800'); INSERT INTO sys_city VALUES ('230804', '前进区', '230800'); INSERT INTO sys_city VALUES ('230805', '东风区', '230800'); INSERT INTO sys_city VALUES ('230811', '郊区', '230800'); INSERT INTO sys_city VALUES ('230822', '桦南县', '230800'); INSERT INTO sys_city VALUES ('230826', '桦川县', '230800'); INSERT INTO sys_city VALUES ('230828', '汤原县', '230800'); INSERT INTO sys_city VALUES ('230833', '抚远县', '230800'); INSERT INTO sys_city VALUES ('230881', '同江市', '230800'); INSERT INTO sys_city VALUES ('230882', '富锦市', '230800'); INSERT INTO sys_city VALUES ('230900', '七台河市', '230000'); INSERT INTO sys_city VALUES ('230902', '新兴区', '230900'); INSERT INTO sys_city VALUES ('230903', '桃山区', '230900'); INSERT INTO sys_city VALUES ('230904', '茄子河区', '230900'); INSERT INTO sys_city VALUES ('230921', '勃利县', '230900'); INSERT INTO sys_city VALUES ('231000', '牡丹江市', '230000'); INSERT INTO sys_city VALUES ('231002', '东安区', '231000'); INSERT INTO sys_city VALUES ('231003', '阳明区', '231000'); INSERT INTO sys_city VALUES ('231004', '爱民区', '231000'); INSERT INTO sys_city VALUES ('231005', '西安区', '231000'); INSERT INTO sys_city VALUES ('231024', '东宁县', '231000'); INSERT INTO sys_city VALUES ('231025', '林口县', '231000'); INSERT INTO sys_city VALUES ('231081', '绥芬河市', '231000'); INSERT INTO sys_city VALUES ('231083', '海林市', '231000'); INSERT INTO sys_city VALUES ('231084', '宁安市', '231000'); INSERT INTO sys_city VALUES ('231085', '穆棱市', '231000'); INSERT INTO sys_city VALUES ('231100', '黑河市', '230000'); INSERT INTO sys_city VALUES ('231102', '爱辉区', '231100'); INSERT INTO sys_city VALUES ('231121', '嫩江县', '231100'); INSERT INTO sys_city VALUES ('231123', '逊克县', '231100'); INSERT INTO sys_city VALUES ('231124', '孙吴县', '231100'); INSERT INTO sys_city VALUES ('231181', '北安市', '231100'); INSERT INTO sys_city VALUES ('231182', '五大连池市', '231100'); INSERT INTO sys_city VALUES ('231200', '绥化市', '230000'); INSERT INTO sys_city VALUES ('231202', '北林区', '231200'); INSERT INTO sys_city VALUES ('231221', '望奎县', '231200'); INSERT INTO sys_city VALUES ('231222', '兰西县', '231200'); INSERT INTO sys_city VALUES ('231223', '青冈县', '231200'); INSERT INTO sys_city VALUES ('231224', '庆安县', '231200'); INSERT INTO sys_city VALUES ('231225', '明水县', '231200'); INSERT INTO sys_city VALUES ('231226', '绥棱县', '231200'); INSERT INTO sys_city VALUES ('231281', '安达市', '231200'); INSERT INTO sys_city VALUES ('231282', '肇东市', '231200'); INSERT INTO sys_city VALUES ('231283', '海伦市', '231200'); INSERT INTO sys_city VALUES ('232700', '大兴安岭地区', '230000'); INSERT INTO sys_city VALUES ('232721', '呼玛县', '232700'); INSERT INTO sys_city VALUES ('232722', '塔河县', '232700'); INSERT INTO sys_city VALUES ('232723', '漠河县', '232700'); INSERT INTO sys_city VALUES ('310000', '上海市', '0'); INSERT INTO sys_city VALUES ('310101', '黄浦区', '310100'); INSERT INTO sys_city VALUES ('310104', '徐汇区', '310100'); INSERT INTO sys_city VALUES ('310105', '长宁区', '310100'); INSERT INTO sys_city VALUES ('310106', '静安区', '310100'); INSERT INTO sys_city VALUES ('310107', '普陀区', '310100'); INSERT INTO sys_city VALUES ('310108', '闸北区', '310100'); INSERT INTO sys_city VALUES ('310109', '虹口区', '310100'); INSERT INTO sys_city VALUES ('310110', '杨浦区', '310100'); INSERT INTO sys_city VALUES ('310112', '闵行区', '310100'); INSERT INTO sys_city VALUES ('310113', '宝山区', '310100'); INSERT INTO sys_city VALUES ('310114', '嘉定区', '310100'); INSERT INTO sys_city VALUES ('310115', '浦东新区', '310100'); INSERT INTO sys_city VALUES ('310116', '金山区', '310100'); INSERT INTO sys_city VALUES ('310117', '松江区', '310100'); INSERT INTO sys_city VALUES ('310118', '青浦区', '310100'); INSERT INTO sys_city VALUES ('310120', '奉贤区', '310100'); INSERT INTO sys_city VALUES ('310230', '崇明县', '310200'); INSERT INTO sys_city VALUES ('320000', '江苏省', '0'); INSERT INTO sys_city VALUES ('320100', '南京市', '320000'); INSERT INTO sys_city VALUES ('320102', '玄武区', '320100'); INSERT INTO sys_city VALUES ('320104', '秦淮区', '320100'); INSERT INTO sys_city VALUES ('320105', '建邺区', '320100'); INSERT INTO sys_city VALUES ('320106', '鼓楼区', '320100'); INSERT INTO sys_city VALUES ('320111', '浦口区', '320100'); INSERT INTO sys_city VALUES ('320113', '栖霞区', '320100'); INSERT INTO sys_city VALUES ('320114', '雨花台区', '320100'); INSERT INTO sys_city VALUES ('320115', '江宁区', '320100'); INSERT INTO sys_city VALUES ('320116', '六合区', '320100'); INSERT INTO sys_city VALUES ('320117', '溧水区', '320100'); INSERT INTO sys_city VALUES ('320118', '高淳区', '320100'); INSERT INTO sys_city VALUES ('320200', '无锡市', '320000'); INSERT INTO sys_city VALUES ('320202', '崇安区', '320200'); INSERT INTO sys_city VALUES ('320203', '南长区', '320200'); INSERT INTO sys_city VALUES ('320204', '北塘区', '320200'); INSERT INTO sys_city VALUES ('320205', '锡山区', '320200'); INSERT INTO sys_city VALUES ('320206', '惠山区', '320200'); INSERT INTO sys_city VALUES ('320211', '滨湖区', '320200'); INSERT INTO sys_city VALUES ('320281', '江阴市', '320200'); INSERT INTO sys_city VALUES ('320282', '宜兴市', '320200'); INSERT INTO sys_city VALUES ('320300', '徐州市', '320000'); INSERT INTO sys_city VALUES ('320302', '鼓楼区', '320300'); INSERT INTO sys_city VALUES ('320303', '云龙区', '320300'); INSERT INTO sys_city VALUES ('320305', '贾汪区', '320300'); INSERT INTO sys_city VALUES ('320311', '泉山区', '320300'); INSERT INTO sys_city VALUES ('320312', '铜山区', '320300'); INSERT INTO sys_city VALUES ('320321', '丰县', '320300'); INSERT INTO sys_city VALUES ('320322', '沛县', '320300'); INSERT INTO sys_city VALUES ('320324', '睢宁县', '320300'); INSERT INTO sys_city VALUES ('320381', '新沂市', '320300'); INSERT INTO sys_city VALUES ('320382', '邳州市', '320300'); INSERT INTO sys_city VALUES ('320400', '常州市', '320000'); INSERT INTO sys_city VALUES ('320402', '天宁区', '320400'); INSERT INTO sys_city VALUES ('320404', '钟楼区', '320400'); INSERT INTO sys_city VALUES ('320411', '新北区', '320400'); INSERT INTO sys_city VALUES ('320412', '武进区', '320400'); INSERT INTO sys_city VALUES ('320413', '金坛区', '320400'); INSERT INTO sys_city VALUES ('320481', '溧阳市', '320400'); INSERT INTO sys_city VALUES ('320500', '苏州市', '320000'); INSERT INTO sys_city VALUES ('320505', '虎丘区', '320500'); INSERT INTO sys_city VALUES ('320506', '吴中区', '320500'); INSERT INTO sys_city VALUES ('320507', '相城区', '320500'); INSERT INTO sys_city VALUES ('320508', '姑苏区', '320500'); INSERT INTO sys_city VALUES ('320509', '吴江区', '320500'); INSERT INTO sys_city VALUES ('320581', '常熟市', '320500'); INSERT INTO sys_city VALUES ('320582', '张家港市', '320500'); INSERT INTO sys_city VALUES ('320583', '昆山市', '320500'); INSERT INTO sys_city VALUES ('320585', '太仓市', '320500'); INSERT INTO sys_city VALUES ('320600', '南通市', '320000'); INSERT INTO sys_city VALUES ('320602', '崇川区', '320600'); INSERT INTO sys_city VALUES ('320611', '港闸区', '320600'); INSERT INTO sys_city VALUES ('320612', '通州区', '320600'); INSERT INTO sys_city VALUES ('320621', '海安县', '320600'); INSERT INTO sys_city VALUES ('320623', '如东县', '320600'); INSERT INTO sys_city VALUES ('320681', '启东市', '320600'); INSERT INTO sys_city VALUES ('320682', '如皋市', '320600'); INSERT INTO sys_city VALUES ('320684', '海门市', '320600'); INSERT INTO sys_city VALUES ('320700', '连云港市', '320000'); INSERT INTO sys_city VALUES ('320703', '连云区', '320700'); INSERT INTO sys_city VALUES ('320706', '海州区', '320700'); INSERT INTO sys_city VALUES ('320707', '赣榆区', '320700'); INSERT INTO sys_city VALUES ('320722', '东海县', '320700'); INSERT INTO sys_city VALUES ('320723', '灌云县', '320700'); INSERT INTO sys_city VALUES ('320724', '灌南县', '320700'); INSERT INTO sys_city VALUES ('320800', '淮安市', '320000'); INSERT INTO sys_city VALUES ('320802', '清河区', '320800'); INSERT INTO sys_city VALUES ('320803', '淮安区', '320800'); INSERT INTO sys_city VALUES ('320804', '淮阴区', '320800'); INSERT INTO sys_city VALUES ('320811', '清浦区', '320800'); INSERT INTO sys_city VALUES ('320826', '涟水县', '320800'); INSERT INTO sys_city VALUES ('320829', '洪泽县', '320800'); INSERT INTO sys_city VALUES ('320830', '盱眙县', '320800'); INSERT INTO sys_city VALUES ('320831', '金湖县', '320800'); INSERT INTO sys_city VALUES ('320900', '盐城市', '320000'); INSERT INTO sys_city VALUES ('320902', '亭湖区', '320900'); INSERT INTO sys_city VALUES ('320903', '盐都区', '320900'); INSERT INTO sys_city VALUES ('320904', '大丰区', '320900'); INSERT INTO sys_city VALUES ('320921', '响水县', '320900'); INSERT INTO sys_city VALUES ('320922', '滨海县', '320900'); INSERT INTO sys_city VALUES ('320923', '阜宁县', '320900'); INSERT INTO sys_city VALUES ('320924', '射阳县', '320900'); INSERT INTO sys_city VALUES ('320925', '建湖县', '320900'); INSERT INTO sys_city VALUES ('320981', '东台市', '320900'); INSERT INTO sys_city VALUES ('321000', '扬州市', '320000'); INSERT INTO sys_city VALUES ('321002', '广陵区', '321000'); INSERT INTO sys_city VALUES ('321003', '邗江区', '321000'); INSERT INTO sys_city VALUES ('321012', '江都区', '321000'); INSERT INTO sys_city VALUES ('321023', '宝应县', '321000'); INSERT INTO sys_city VALUES ('321081', '仪征市', '321000'); INSERT INTO sys_city VALUES ('321084', '高邮市', '321000'); INSERT INTO sys_city VALUES ('321100', '镇江市', '320000'); INSERT INTO sys_city VALUES ('321102', '京口区', '321100'); INSERT INTO sys_city VALUES ('321111', '润州区', '321100'); INSERT INTO sys_city VALUES ('321112', '丹徒区', '321100'); INSERT INTO sys_city VALUES ('321181', '丹阳市', '321100'); INSERT INTO sys_city VALUES ('321182', '扬中市', '321100'); INSERT INTO sys_city VALUES ('321183', '句容市', '321100'); INSERT INTO sys_city VALUES ('321200', '泰州市', '320000'); INSERT INTO sys_city VALUES ('321202', '海陵区', '321200'); INSERT INTO sys_city VALUES ('321203', '高港区', '321200'); INSERT INTO sys_city VALUES ('321204', '姜堰区', '321200'); INSERT INTO sys_city VALUES ('321281', '兴化市', '321200'); INSERT INTO sys_city VALUES ('321282', '靖江市', '321200'); INSERT INTO sys_city VALUES ('321283', '泰兴市', '321200'); INSERT INTO sys_city VALUES ('321300', '宿迁市', '320000'); INSERT INTO sys_city VALUES ('321302', '宿城区', '321300'); INSERT INTO sys_city VALUES ('321311', '宿豫区', '321300'); INSERT INTO sys_city VALUES ('321322', '沭阳县', '321300'); INSERT INTO sys_city VALUES ('321323', '泗阳县', '321300'); INSERT INTO sys_city VALUES ('321324', '泗洪县', '321300'); INSERT INTO sys_city VALUES ('330000', '浙江省', '0'); INSERT INTO sys_city VALUES ('330100', '杭州市', '330000'); INSERT INTO sys_city VALUES ('330102', '上城区', '330100'); INSERT INTO sys_city VALUES ('330103', '下城区', '330100'); INSERT INTO sys_city VALUES ('330104', '江干区', '330100'); INSERT INTO sys_city VALUES ('330105', '拱墅区', '330100'); INSERT INTO sys_city VALUES ('330106', '西湖区', '330100'); INSERT INTO sys_city VALUES ('330108', '滨江区', '330100'); INSERT INTO sys_city VALUES ('330109', '萧山区', '330100'); INSERT INTO sys_city VALUES ('330110', '余杭区', '330100'); INSERT INTO sys_city VALUES ('330111', '富阳区', '330100'); INSERT INTO sys_city VALUES ('330122', '桐庐县', '330100'); INSERT INTO sys_city VALUES ('330127', '淳安县', '330100'); INSERT INTO sys_city VALUES ('330182', '建德市', '330100'); INSERT INTO sys_city VALUES ('330185', '临安市', '330100'); INSERT INTO sys_city VALUES ('330200', '宁波市', '330000'); INSERT INTO sys_city VALUES ('330203', '海曙区', '330200'); INSERT INTO sys_city VALUES ('330204', '江东区', '330200'); INSERT INTO sys_city VALUES ('330205', '江北区', '330200'); INSERT INTO sys_city VALUES ('330206', '北仑区', '330200'); INSERT INTO sys_city VALUES ('330211', '镇海区', '330200'); INSERT INTO sys_city VALUES ('330212', '鄞州区', '330200'); INSERT INTO sys_city VALUES ('330225', '象山县', '330200'); INSERT INTO sys_city VALUES ('330226', '宁海县', '330200'); INSERT INTO sys_city VALUES ('330281', '余姚市', '330200'); INSERT INTO sys_city VALUES ('330282', '慈溪市', '330200'); INSERT INTO sys_city VALUES ('330283', '奉化市', '330200'); INSERT INTO sys_city VALUES ('330300', '温州市', '330000'); INSERT INTO sys_city VALUES ('330302', '鹿城区', '330300'); INSERT INTO sys_city VALUES ('330303', '龙湾区', '330300'); INSERT INTO sys_city VALUES ('330304', '瓯海区', '330300'); INSERT INTO sys_city VALUES ('330305', '洞头区', '330300'); INSERT INTO sys_city VALUES ('330324', '永嘉县', '330300'); INSERT INTO sys_city VALUES ('330326', '平阳县', '330300'); INSERT INTO sys_city VALUES ('330327', '苍南县', '330300'); INSERT INTO sys_city VALUES ('330328', '文成县', '330300'); INSERT INTO sys_city VALUES ('330329', '泰顺县', '330300'); INSERT INTO sys_city VALUES ('330381', '瑞安市', '330300'); INSERT INTO sys_city VALUES ('330382', '乐清市', '330300'); INSERT INTO sys_city VALUES ('330400', '嘉兴市', '330000'); INSERT INTO sys_city VALUES ('330402', '南湖区', '330400'); INSERT INTO sys_city VALUES ('330411', '秀洲区', '330400'); INSERT INTO sys_city VALUES ('330421', '嘉善县', '330400'); INSERT INTO sys_city VALUES ('330424', '海盐县', '330400'); INSERT INTO sys_city VALUES ('330481', '海宁市', '330400'); INSERT INTO sys_city VALUES ('330482', '平湖市', '330400'); INSERT INTO sys_city VALUES ('330483', '桐乡市', '330400'); INSERT INTO sys_city VALUES ('330500', '湖州市', '330000'); INSERT INTO sys_city VALUES ('330502', '吴兴区', '330500'); INSERT INTO sys_city VALUES ('330503', '南浔区', '330500'); INSERT INTO sys_city VALUES ('330521', '德清县', '330500'); INSERT INTO sys_city VALUES ('330522', '长兴县', '330500'); INSERT INTO sys_city VALUES ('330523', '安吉县', '330500'); INSERT INTO sys_city VALUES ('330600', '绍兴市', '330000'); INSERT INTO sys_city VALUES ('330602', '越城区', '330600'); INSERT INTO sys_city VALUES ('330603', '柯桥区', '330600'); INSERT INTO sys_city VALUES ('330604', '上虞区', '330600'); INSERT INTO sys_city VALUES ('330624', '新昌县', '330600'); INSERT INTO sys_city VALUES ('330681', '诸暨市', '330600'); INSERT INTO sys_city VALUES ('330683', '嵊州市', '330600'); INSERT INTO sys_city VALUES ('330700', '金华市', '330000'); INSERT INTO sys_city VALUES ('330702', '婺城区', '330700'); INSERT INTO sys_city VALUES ('330703', '金东区', '330700'); INSERT INTO sys_city VALUES ('330723', '武义县', '330700'); INSERT INTO sys_city VALUES ('330726', '浦江县', '330700'); INSERT INTO sys_city VALUES ('330727', '磐安县', '330700'); INSERT INTO sys_city VALUES ('330781', '兰溪市', '330700'); INSERT INTO sys_city VALUES ('330782', '义乌市', '330700'); INSERT INTO sys_city VALUES ('330783', '东阳市', '330700'); INSERT INTO sys_city VALUES ('330784', '永康市', '330700'); INSERT INTO sys_city VALUES ('330800', '衢州市', '330000'); INSERT INTO sys_city VALUES ('330802', '柯城区', '330800'); INSERT INTO sys_city VALUES ('330803', '衢江区', '330800'); INSERT INTO sys_city VALUES ('330822', '常山县', '330800'); INSERT INTO sys_city VALUES ('330824', '开化县', '330800'); INSERT INTO sys_city VALUES ('330825', '龙游县', '330800'); INSERT INTO sys_city VALUES ('330881', '江山市', '330800'); INSERT INTO sys_city VALUES ('330900', '舟山市', '330000'); INSERT INTO sys_city VALUES ('330902', '定海区', '330900'); INSERT INTO sys_city VALUES ('330903', '普陀区', '330900'); INSERT INTO sys_city VALUES ('330921', '岱山县', '330900'); INSERT INTO sys_city VALUES ('330922', '嵊泗县', '330900'); INSERT INTO sys_city VALUES ('331000', '台州市', '330000'); INSERT INTO sys_city VALUES ('331002', '椒江区', '331000'); INSERT INTO sys_city VALUES ('331003', '黄岩区', '331000'); INSERT INTO sys_city VALUES ('331004', '路桥区', '331000'); INSERT INTO sys_city VALUES ('331021', '玉环县', '331000'); INSERT INTO sys_city VALUES ('331022', '三门县', '331000'); INSERT INTO sys_city VALUES ('331023', '天台县', '331000'); INSERT INTO sys_city VALUES ('331024', '仙居县', '331000'); INSERT INTO sys_city VALUES ('331081', '温岭市', '331000'); INSERT INTO sys_city VALUES ('331082', '临海市', '331000'); INSERT INTO sys_city VALUES ('331100', '丽水市', '330000'); INSERT INTO sys_city VALUES ('331102', '莲都区', '331100'); INSERT INTO sys_city VALUES ('331121', '青田县', '331100'); INSERT INTO sys_city VALUES ('331122', '缙云县', '331100'); INSERT INTO sys_city VALUES ('331123', '遂昌县', '331100'); INSERT INTO sys_city VALUES ('331124', '松阳县', '331100'); INSERT INTO sys_city VALUES ('331125', '云和县', '331100'); INSERT INTO sys_city VALUES ('331126', '庆元县', '331100'); INSERT INTO sys_city VALUES ('331127', '景宁畲族自治县', '331100'); INSERT INTO sys_city VALUES ('331181', '龙泉市', '331100'); INSERT INTO sys_city VALUES ('340000', '安徽省', '0'); INSERT INTO sys_city VALUES ('340100', '合肥市', '340000'); INSERT INTO sys_city VALUES ('340102', '瑶海区', '340100'); INSERT INTO sys_city VALUES ('340103', '庐阳区', '340100'); INSERT INTO sys_city
insert中加入where条件判断,解决插入重复数据的问题
对于会员注册,我们经常会做唯一性验证,通常情况下我们有这两种方式: n1. 数据库表设计的时候loginName增加唯一约束 n2. 注册之前先查一下然后再去进行插入操作针对以上两种情况,第一种情况,增加约束的话,是最有效的,但如果表结构已经确定了,再修改起来反而不太好,所以这里不多说。我们这里就只说第二种情况,这种情况看似无懈可击,但是确实有致命的bug,如果两个人同时填好注册信息,数123一起点
全国省市数据库
<em>insert</em> into promary <em>values</em>(1,'北京市') <em>insert</em> into promary <em>values</em>(2,'天津市') <em>insert</em> into promary <em>values</em>(3,'上海市') <em>insert</em> into promary <em>values</em>(4,'重庆市') <em>insert</em> into promary <em>values</em>(5,'河北省') <em>insert</em> into promary <em>values</em>(6,'山西省') <em>insert</em> into promary <em>values</em>(7,'台湾省') <em>insert</em> into city <em>values</em>(1,'石家庄市',5) <em>insert</em> into city <em>values</em>(2,'唐山市',5) <em>insert</em> into city <em>values</em>(3,'秦皇岛市',5) <em>insert</em> into city <em>values</em>(4,'邯郸市',5) <em>insert</em> into city <em>values</em>(5,'邢台市',5) <em>insert</em> into city <em>values</em>(6,'保定市',5) <em>insert</em> into city <em>values</em>(7,'张家口市',5) <em>insert</em> into city <em>values</em>(8,'承德市',5) <em>insert</em> into city <em>values</em>(9,'沧州市',5) <em>insert</em> into city <em>values</em>(10,'廊坊市',5)
oracle插入数据的时候报错:ORA-00928: 缺失 SELECT 关键字
比如:插入数据的时候是这样的<em>insert</em> into a value('哈哈');报的是这样的错误:ORA-00928: 缺失 SELECT 关键字其实就是value少了一个s,在oracle中,插入数据要用value...
SQL 合并两个字段的数据 或者合并时添加符号 如:括号
select  columnName1  || '('||   columnName2  from tableName;
myeclipse部署到tomcat的web项目后面括号中引用了别的项目的名字
myeclipse部署到tomcat的web项目<em>后面</em>的<em>括号</em>中引用了别的项目的名字nn nn解决方法:nn出现这种状况是因为你这个部署到tomcat的项目是复制过来的,所以配置里还保存着别的项目引用,所以断点调试时,会调到别的项目里去。nn修改web项目所在目录.settings目录下的:http://www.y​ayihouse.com/yayishuwu/chapter/1653...
最新全国省、市地区联动数据库文件 area.sql
省市联动,-- Table structure for province -- ---------------------------- DROP TABLE IF EXISTS `province`; CREATE TABLE `province` ( `id` int(5) NOT NULL auto_increment, `name` varchar(255) default '', `pid` int(5) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of province -- ---------------------------- INSERT INTO `province` VALUES ('82', '北京市', '0'); INSERT INTO `province` VALUES ('83', '天津市', '0'); INSERT INTO `province` VALUES ('84', '河北省', '0'); INSERT INTO `province` VALUES ('85', '山西省', '0'); INSERT INTO `province` VALUES ('86', '内蒙古自治区', '0'); INSERT INTO `province` VALUES ('87', '辽宁省', '0'); INSERT INTO `province` VALUES ('88', '吉林省', '0'); INSERT INTO `province` VALUES ('89', '黑龙江省', '0'); INSERT INTO `province` VALUES ('90', '上海市', '0'); INSERT INTO `province` VALUES ('91', '江苏省', '0'); INSERT INTO `province` VALUES ('92', '浙江省', '0'); INSERT INTO `province` VALUES ('93', '安徽省', '0'); INSERT INTO `province` VALUES ('94', '福建省', '0'); INSERT INTO `province` VALUES ('95', '江西省', '0'); INSERT INTO `province` VALUES ('96', '山东省', '0'); INSERT INTO `province` VALUES ('97', '河南省', '0'); INSERT INTO `province` VALUES ('98', '湖北省', '0'); INSERT INTO `province` VALUES ('99', '湖南省', '0'); INSERT INTO `province` VALUES ('100', '广东省', '0'); INSERT INTO `province` VALUES ('101', '广西壮族自治区', '0'); INSERT INTO `province` VALUES ('102', '海南省', '0'); INSERT INTO `province` VALUES ('103', '重庆市', '0'); INSERT INTO `province` VALUES ('104', '四川省', '0'); INSERT INTO `province` VALUES ('105', '贵州省', '0'); INSERT INTO `province` VALUES ('106', '云南省', '0'); INSERT INTO `province` VALUES ('107', '西藏自治区', '0'); INSERT INTO `province` VALUES ('108', '陕西省', '0'); INSERT INTO `province` VALUES ('109', '甘肃省', '0'); INSERT INTO `province` VALUES ('110', '青海省', '0'); INSERT INTO `province` VALUES ('111', '宁夏回族自治区', '0'); INSERT INTO `province` VALUES ('112', '新疆维吾尔自治区', '0'); INSERT INTO `province` VALUES ('113', '台湾省', '0'); INSERT INTO `province` VALUES ('114', '香港特别行政区', '0'); INSERT INTO `province` VALUES ('115', '澳门特别行政区', '0'); INSERT INTO `province` VALUES ('116', '北京辖区', '82'); INSERT INTO `province` VALUES ('117', '北京辖县', '82'); INSERT INTO `province` VALUES ('118', '天津辖区', '83'); INSERT INTO `province` VALUES ('119', '天津辖县', '83'); INSERT INTO `province` VALUES ('120', '重庆辖区', '103'); INSERT INTO `province` VALUES ('121', '重庆辖县', '103'); INSERT INTO `province` VALUES ('122', '上海辖区', '90'); INSERT INTO `province` VALUES ('123', '上海辖县', '90'); INSERT INTO `province` VALUES ('124', '东城区', '116'); INSERT INTO `province` VALUES ('125', '西城区', '116');
经典而又简单的student数据库
USE master nGo nIF EXISTS(SELECT * FROM SYSDATABASES WHERE NAME=’Students’) nDROP DATABASE Students nGOCREATE DATABASE Students –创建学生数据库 nON PRIMARY n( n NAME=’Students_data’
图书超市.rar
图书超市 <em>insert</em> into booktype <em>values</em> &quot;历史&quot; <em>insert</em> into booktype <em>values</em> &quot;军事&quot; <em>insert</em> into booktype <em>values</em> &quot;心里&quot; <em>insert</em> into booktype <em>values</em> &quot;地理&quot; <em>insert</em> into users <em>values</em> &quot;qingshou&quot; &quot;shoushou&quot; <em>insert</em> into users <em>values</em> &quot;qingshou2&quot; &quot;shoushou2&quot; <em>insert</em> into book <em>values</em> &quot;孙悟空与林黛玉不得不说的故事&quot; 1 50 20 <em>insert</em> into book <em>values</em> &quot;猪八戒与潘金莲不得不说的故事&quot; 1 30 10 <em>insert</em> into book <em>values</em> &quot;唐僧大战排骨精&quot; 2 20 60 ">图书超市 <em>insert</em> into booktype <em>values</em> &quot;历史&quot; <em>insert</em> into booktype <em>values</em> &quot;军事&quot; <em>insert</em> into booktype <em>values</em> &quot;心里&quot; <em>insert</em> into booktype <em>values</em> &quot;地理&quot; <em>insert</em> into users <em>values</em> &quot;qingshou&quot; &quot;shoushou&quot; <em>insert</em> into users <em>values</em> & [更多]
创建动态的sql语句
举个栗子:rn数据库有个staff表,表结构为:rnrnrnrnrnidrnnamernagernrnrnrn插入数据库的数据:rnid='001'rnname='mike'rnage=20rnrn构造一个动态变化的字典:rndata={ 'id':'001', 'name':'mike', 'age':20}rnrn具体代码为:rnimport pymy<em>sql</em>rnrndb = pymy<em>sql</em>.connect(host='localhost'...
SQL查询操作
SQL查询操作nnnn普通查询nnn创建数据库nnnnncreate database python_test_1 charset=utf8;nnn使用数据库nnnnnuse python_test_1;nnn显示当前使用的数据库nnnnnselect database();nnn创建一个数据表nnnnncreate table <em>student</em>s(n id int unsigned prim...
mysqlmysql
INSERT INTO `province` VALUES ('82', '北京市', '0'); INSERT INTO `province` VALUES ('83', '天津市', '0'); INSERT INTO `province` VALUES ('84', '河北省', '0'); INSERT INTO `province` VALUES ('85', '山西省', '0'); INSERT INTO `province` VALUES ('86', '内蒙古自治区', '0'); INSERT INTO `province` VALUES ('87', '辽宁省', '0'); INSERT INTO `province` VALUES ('88', '吉林省', '0'); INSERT INTO `province` VALUES ('89', '黑龙江省', '0'); INSERT INTO `province` VALUES ('90', '上海市', '0');
国家、城市、全球国家国旗、中国省市县三级SQL
压缩包中包含:纯中文世界各国及城市 SQL、中国-省市县三级数据库SQL、中英文兼备的全球所有国家及国旗_SQL <em>格式</em>如: INSERT INTO `loclist` VALUES (1,'中国',1,'北京',1,'东城')。 INSERT INTO `fch_district` VALUES (1,'001002001002','河东','001002001',360,'中国/天津/市辖区/河东','区',4,'hd','hedong','022','300171')。 INSERT INTO hb_country (id, englishname, chinesename, abbreviation, code) VALUES (1, 'Afghanistan', '阿富汗', 'AF', '93')。
mybatis插入多条记录
今天遇到一个批量保存数据的问题,很自然的想到了使用<em>insert</em> into <em>values</em>(),()…这种方式保存数据,于是在mybatis配置文件中使用如下配置:n <em>insert</em> into T_PA_DATE (FID, FDATE_VALUE, FSELECTED, n FD
熟悉复杂的SQL查询方法
 查询(select)nnselect的使用方法最为复杂,借用一下我们数据库老师的上机实习来说明select如何使用,感谢jjj老师。nn nn实习:给出学生-课程数据库的三个表nn    ①学生表. Student(Sno,Sname,Ssex,Sage,Sdept) Sno为主键;nn       说明:Sno 学号,Sname姓名,Ssex 性别,Sage 年龄,Sdept所在系nn    ...
sqlite-netFx451-setup-bundle-x86-2013-1.0.97.0.exe
32位<em>sql</em>ite dll 动态库 static void Main(string[] args) { SQLiteConnection conn = null; string dbPath = "Data Source =" + Environment.CurrentDirectory + "/test.db"; conn = new SQLiteConnection(dbPath);//创建数据库实例,指定文件位置 conn.Open();//打开数据库,若文件不存在会自动创建 string <em>sql</em> = "CREATE TABLE IF NOT EXISTS <em>student</em>(id integer, name varchar(20), sex varchar(2));";//建表语句 SQLiteCommand cmdCreateTable = new SQLiteCommand(<em>sql</em>, conn); cmdCreateTable.ExecuteNonQuery();//如果表不存在,创建数据表 SQLiteCommand cmdInsert = new SQLiteCommand(conn); cmdInsert.CommandText = "INSERT INTO <em>student</em> VALUES(1, '小红', '男')";//插入几条数据 cmdInsert.ExecuteNonQuery(); cmdInsert.CommandText = "INSERT INTO <em>student</em> VALUES(2, '小李', '女')"; cmdInsert.ExecuteNonQuery(); cmdInsert.CommandText = "INSERT INTO <em>student</em> VALUES(3, '小明', '男')"; cmdInsert.ExecuteNonQuery(); conn.Close(); }
sqlite-netFx451-setup-bundle-x64-2013-1.0.97.0.exe
64位<em>sql</em>ite使用的动态库 static void Main(string[] args) { SQLiteConnection conn = null; string dbPath = "Data Source =" + Environment.CurrentDirectory + "/test.db"; conn = new SQLiteConnection(dbPath);//创建数据库实例,指定文件位置 conn.Open();//打开数据库,若文件不存在会自动创建 string <em>sql</em> = "CREATE TABLE IF NOT EXISTS <em>student</em>(id integer, name varchar(20), sex varchar(2));";//建表语句 SQLiteCommand cmdCreateTable = new SQLiteCommand(<em>sql</em>, conn); cmdCreateTable.ExecuteNonQuery();//如果表不存在,创建数据表 SQLiteCommand cmdInsert = new SQLiteCommand(conn); cmdInsert.CommandText = "INSERT INTO <em>student</em> VALUES(1, '小红', '男')";//插入几条数据 cmdInsert.ExecuteNonQuery(); cmdInsert.CommandText = "INSERT INTO <em>student</em> VALUES(2, '小李', '女')"; cmdInsert.ExecuteNonQuery(); cmdInsert.CommandText = "INSERT INTO <em>student</em> VALUES(3, '小明', '男')"; cmdInsert.ExecuteNonQuery(); conn.Close(); }
新增表记录(insert into)
nselect * from [dbo].[userinfo];nn<em>insert</em> into userinfo(userid,username,email)--插入一行数据,要一一对应n<em>values</em>('genve','张三','genve@qq.com');nnselect * from [dbo].[userinfo];nn<em>insert</em> into userinfo(userid,username,...
数据库练习(知识点蛮多)
/* Navicat SQL Server Data Transfer Source Server : . Source Server Version : 105000 Source Host : .:1433 Source Database : testlianxi Source Schema : dbo Target Server Type : SQL Server Target Server Version : 105000 File Encoding : 65001 Date: 2015-11-10 15:52:19 */ -- ---------------------------- -- Table structure for cj_t -- ---------------------------- DROP TABLE [dbo].[cj_t] GO CREATE TABLE [dbo].[cj_t] ( [id] int NOT NULL IDENTITY(1,1) , [xsid] int NOT NULL , [kcid] int NOT NULL , [cj] float NOT NULL , [t] int NOT NULL ) GO -- ---------------------------- -- Records of cj_t -- ---------------------------- SET IDENTITY_INSERT [dbo].[cj_t] ON GO SET IDENTITY_INSERT [dbo].[cj_t] OFF GO -- ---------------------------- -- Table structure for kc_t -- ---------------------------- DROP TABLE [dbo].[kc_t] GO CREATE TABLE [dbo].[kc_t] ( [id] int NOT NULL IDENTITY(1,1) , [kcmc] varchar(60) NOT NULL ) GO -- ---------------------------- -- Records of kc_t -- ---------------------------- SET IDENTITY_INSERT [dbo].[kc_t] ON GO SET IDENTITY_INSERT [dbo].[kc_t] OFF GO -- ---------------------------- -- Table structure for xs_t -- ---------------------------- DROP TABLE [dbo].[xs_t] GO CREATE TABLE [dbo].[xs_t] ( [id] int NOT NULL IDENTITY(1,1) , [xh] varchar(12) NOT NULL , [xm] varchar(50) NOT NULL , [bj] varchar(20) NOT NULL ) GO -- ---------------------------- -- Records of xs_t -- ---------------------------- SET IDENTITY_INSERT [dbo].[xs_t] ON GO SET IDENTITY_INSERT [dbo].[xs_t] OFF GO -- ---------------------------- -- Indexes structure for table cj_t -- ---------------------------- -- ---------------------------- -- Primary Key structure for table cj_t -- ---------------------------- ALTER TABLE [dbo].[cj_t] ADD PRIMARY KEY ([id]) GO -- ---------------------------- -- Indexes structure for table kc_t -- ---------------------------- -- ---------------------------- -- Primary Key structure for table kc_t -- ---------------------------- ALTER TABLE [dbo].[kc_t] ADD PRIMARY KEY ([id]) GO -- ---------------------------- -- Indexes structure for table xs_t -- ---------------------------- -- ---------------------------- -- Primary Key structure for table xs_t -- ---------------------------- ALTER TABLE [dbo].[xs_t] ADD PRIMARY KEY ([id]) GO INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'1', N'数学') INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'2', N'英语') INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'3', N'语文') INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'4', N'科学') INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'5', N'政治') <em>insert</em> into xs_t <em>values</em>('3','Lily','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,55,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,73,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,66,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,75,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,73,1) <em>insert</em> into xs_t <em>values</em>('1','Tom','三三班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,67,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,62,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,78,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,60,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,72,1) <em>insert</em> into xs_t <em>values</em>('2','Lisa','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,97,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,76,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,56,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,76,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,71,1) <em>insert</em> into xs_t <em>values</em>('5','Jim','三二班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,77,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,98,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,58,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,59,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,79,1) <em>insert</em> into xs_t <em>values</em>('4','Sam','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,91,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,68,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,89,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,68,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,90,1) <em>insert</em> into xs_t <em>values</em>('6','Jack','三五班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,66,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,90,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,57,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,55,1) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,69,1) <em>insert</em> into xs_t <em>values</em>('3','Lily','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,86,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,100,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,80,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,99,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,87,2) <em>insert</em> into xs_t <em>values</em>('1','Tom','三三班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,63,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,64,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,71,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,94,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,62,2) <em>insert</em> into xs_t <em>values</em>('2','Lisa','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,98,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,63,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,56,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,76,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,84,2) <em>insert</em> into xs_t <em>values</em>('5','Jim','三二班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,72,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,57,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,93,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,62,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,98,2) <em>insert</em> into xs_t <em>values</em>('4','Sam','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,82,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,83,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,95,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,75,2) <em>insert</em> into xs_t <em>values</em>('6','Jack','三五班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,85,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,87,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,82,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,82,2) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,65,2) <em>insert</em> into xs_t <em>values</em>('3','Lily','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,96,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,69,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,74,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,81,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,56,3) <em>insert</em> into xs_t <em>values</em>('1','Tom','三三班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,96,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,92,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,63,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,63,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,83,3) <em>insert</em> into xs_t <em>values</em>('2','Lisa','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,57,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,80,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,61,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,80,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,64,3) <em>insert</em> into xs_t <em>values</em>('5','Jim','三二班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,84,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,57,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,90,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,86,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,94,3) <em>insert</em> into xs_t <em>values</em>('4','Sam','三一班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,95,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,58,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,99,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,61,3) <em>insert</em> into xs_t <em>values</em>('6','Jack','三五班') <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),1,94,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),2,96,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),3,68,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),4,77,3) <em>insert</em> into cj_t <em>values</em>(IDENT_CURRENT('xs_t'),5,57,3)
MySQL脚本insert中文失败
环境:nnwin7 cmdnn<em>sql</em>脚本中的语句:nncreate table catalog(nncatalogid int auto_increment not null,nncatalogname varchar(30) not null,nprimary key(catalogid)n);n<em>insert</em> into catalog <em>values</em>(1,'衬衫');
SQLServer中常用语句
SQLServer中常用语句: 插入记录: <em>insert</em> into Student (Sno,Sname,Ssex,Sdept) <em>values</em>('aaa','mary','f','172'); 删除记录: delete from Student where Sno = 'aaa'; .......
sql中如何处理带括号的变量?如何在SQL语句中使用特殊字符?
类似下面的SQL语句将出错。单价后中<em>括号</em>引起出错。n nSELECT  price AS 单价(元) FROM myTable ;n n n如何解处呢?下面两个都不是最好的方法。至少在oracle中不适用。nSELECT  price AS 单价[元] FROM myTable ;nSELECT  price AS 单价(元) FROM myTable ;...
SQL脚本导出器(可直接导出成insert形式的语句)
SQL脚本导出器(可直接导出成<em>insert</em>形式的语句) 如: <em>insert</em> TABLENAME() <em>values</em>()
省市区及地区码.sql
INSERT INTO `t_area_code` VALUES ('1', '110000', '北京市'); INSERT INTO `t_area_code` VALUES ('2', '110100', '北京市市辖区'); INSERT INTO `t_area_code` VALUES ('3', '110101', '北京市东城区'); INSERT INTO `t_area_code` VALUES ('4', '110102', '北京市西城区'); INSERT INTO `t_area_code` VALUES ('5', '110103', '北京市崇文区'); INSERT INTO `t_area_code` VALUES ('6', '110104', '北京市宣武区'); INSERT INTO `t_area_code` VALUES ('7', '110105', '北京市朝阳区'); INSERT INTO `t_area_code` VALUES ('8', '110106', '北京市丰台区'); INSERT INTO `t_area_code` VALUES ('9', '110107', '北京市石景山区'); INSERT INTO `t_area_code` VALUES ('10', '110108', '北京市海淀区'); INSERT INTO `t_area_code` VALUES ('11', '110109', '北京市门头沟区'); INSERT INTO `t_area_code` VALUES ('12', '110111', '北京市房山区'); INSERT INTO `t_area_code` VALUES ('13', '110112', '北京市通州区'); INSERT INTO `t_area_code` VALUES ('14', '110113', '北京市顺义区');
eclipse项目名称后面括号里的名称和项目名称不一样
问题如图所示:rnrn解决方案:rnrn1:项目右键-属性(Properties)-Web Project Setting, 改名称rnrnrnrn注意:这个名字将成为你在浏览器访问的路径rnrnrn2:打开项目目录的.setting文件夹,随便一个文本编辑器打开org.eclipse.wst.common.component文件,修改内容:
2018最新省市县三级联动(截止2018年9月31日)
之前从网上找的三级联动都太老了,数据也都是很久之前的数据,所以自己把从国家统计局扒下来的省市县三级联动数据做了整理,目前最新的三级联动,童叟无欺。大家看北京市和天津市的几个分区就知道是最新的了。 INSERT INTO `address` VALUES (1, '110000', 0, '北京市', 1); INSERT INTO `address` VALUES (2, '110100', 110000, '市辖区', 2); INSERT INTO `address` VALUES (3, '110101', 110100, '东城区', 3); INSERT INTO `address` VALUES (4, '110102', 110100, '西城区', 3); INSERT INTO `address` VALUES (5, '110105', 110100, '朝阳区', 3); INSERT INTO `address` VALUES (6, '110106', 110100, '丰台区', 3); INSERT INTO `address` VALUES (7, '110107', 110100, '石景山区', 3); INSERT INTO `address` VALUES (8, '110108', 110100, '海淀区', 3); INSERT INTO `address` VALUES (9, '110109', 110100, '门头沟区', 3); INSERT INTO `address` VALUES (10, '110111', 110100, '房山区', 3); INSERT INTO `address` VALUES (11, '110112', 110100, '通州区', 3); INSERT INTO `address` VALUES (12, '110113', 110100, '顺义区', 3); INSERT INTO `address` VALUES (13, '110114', 110100, '昌平区', 3); INSERT INTO `address` VALUES (14, '110115', 110100, '大兴区', 3); INSERT INTO `address` VALUES (15, '110116', 110100, '怀柔区', 3); INSERT INTO `address` VALUES (16, '110117', 110100, '平谷区', 3); INSERT INTO `address` VALUES (17, '110118', 110100, '密云区', 3); INSERT INTO `address` VALUES (18, '110119', 110100, '延庆区', 3); INSERT INTO `address` VALUES (19, '120000', 0, '天津市', 1); INSERT INTO `address` VALUES (20, '120100', 120000, '市辖区', 2); INSERT INTO `address` VALUES (21, '120101', 120100, '和平区', 3); INSERT INTO `address` VALUES (22, '120102', 120100, '河东区', 3); INSERT INTO `address` VALUES (23, '120103', 120100, '河西区', 3); INSERT INTO `address` VALUES (24, '120104', 120100, '南开区', 3); INSERT INTO `address` VALUES (25, '120105', 120100, '河北区', 3); INSERT INTO `address` VALUES (26, '120106', 120100, '红桥区', 3); INSERT INTO `address` VALUES (27, '120110', 120100, '东丽区', 3); INSERT INTO `address` VALUES (28, '120111', 120100, '西青区', 3); INSERT INTO `address` VALUES (29, '120112', 120100, '津南区', 3); INSERT INTO `address` VALUES (30, '120113', 120100, '北辰区', 3); INSERT INTO `address` VALUES (31, '120114', 120100, '武清区', 3); INSERT INTO `address` VALUES (32, '120115', 120100, '宝坻区', 3); INSERT INTO `address` VALUES (33, '120116', 120100, '滨海新区', 3); INSERT INTO `address` VALUES (34, '120117', 120100, '宁河区', 3); INSERT INTO `address` VALUES (35, '120118', 120100, '静海区', 3); INSERT INTO `address` VALUES (36, '120119', 120100, '蓟州区', 3);
将数据生成为SQL的insert脚本
将数据表的数据,生成为SQL的<em>insert</em>脚本,如:<em>insert</em> into 表名(字段,...) <em>values</em>(值,....)
冰刃 进程管理工具 非常强悍下载
冰刃 的用途我就不用讲了! 很不错的安全工具! 可以结束几乎所有进程 相关下载链接:[url=//download.csdn.net/download/qjhy531/2108716?utm_source=bbsseo]//download.csdn.net/download/qjhy531/2108716?utm_source=bbsseo[/url]
Microwave engineer ppt下载
David的经典教材,授课用的PPT现在已经改成pdf文件,方便阅读 相关下载链接:[url=//download.csdn.net/download/magicdi/2109567?utm_source=bbsseo]//download.csdn.net/download/magicdi/2109567?utm_source=bbsseo[/url]
实现多路数据采集与光纤通信,采用FPGA与dsp5509实现下载
实现多路数据采集与光纤通信,采用FPGA与dsp5509实现 随着传感器、光纤、计算机和信息处理等技术的发展,数据采集技术和数据 采集系统在各个领域迅速地得到了应用。本文研究了数据采集系统在高压设备绝 缘状态监测领域的应用,设计和实现了一套多路数据采集和光纤传输系统。 相关下载链接:[url=//download.csdn.net/download/lgcsanbao123/3074443?utm_source=bbsseo]//download.csdn.net/download/lgcsanbao123/3074443?utm_source=bbsseo[/url]
文章热词 机器学习教程 Objective-C培训 交互设计视频教程 颜色模型 设计制作学习
相关热词 mysql关联查询两次本表 native底部 react extjs glyph 图标 怎样学python 数据库课程设计格式
我们是很有底线的