mysql 报错10614_PostgreSQL转换为Mysql

由于postgresql和mysql的使用方式不同，所以不能直接导出sql转换为mysql所用的，所以

下面是我总结的几点

DROP TABLE IF EXISTS "public"."college";

CREATE TABLE "public"."college" (

"college_id" int4 DEFAULT nextval('college_college_id_seq'::regclass) NOT NULL,

"college_code" varchar(50) COLLATE "default" NOT NULL,

"college_name" varchar(100) COLLATE "default" NOT NULL,

"college_web_site" varchar(50) COLLATE "default",

"standby0" varchar(500) COLLATE "default",

"standby4" varchar(500) COLLATE "default",

"standby3" varchar(500) COLLATE "default",

"standby2" varchar(500) COLLATE "default",

"standby1" varchar(500) COLLATE "default"

)

WITH (OIDS=FALSE)

;

-- ----------------------------

-- Records of college

-- ----------------------------

INSERT INTO "public"."college" VALUES ('30','10007','北京理工大学','http://www.bit.edu.cn/',null,null);

INSERT INTO "public"."college" VALUES ('31','10698','西安交通大学','http://www.xjtudlc.com/',null);

INSERT INTO "public"."college" VALUES ('32','11414','中国石油大学(北京)','http://www.cupde.cn/cms/fxlsy/index.htm',null);

INSERT INTO "public"."college" VALUES ('33','10699','西北工业大学','http://www.nwpunec.net/',null);

INSERT INTO "public"."college" VALUES ('34','11415','中国地质大学(北京)','http://www.cugbonline.cn/info.do?columnId=249',null);

INSERT INTO "public"."college" VALUES ('35','10718','陕西师范大学','http://sde.snnu.edu.cn/',null);

INSERT INTO "public"."college" VALUES ('36','','北京大学',null);

INSERT INTO "public"."college" VALUES ('37','10030','北京外国语大学','http://www.beiwaionline.com/',null);

INSERT INTO "public"."college" VALUES ('38','10008','北京科技大学','http://cr.ustb.edu.cn/',null);

INSERT INTO "public"."college" VALUES ('39','10055','南开大学','http://weo.nankai.edu.cn',null);

INSERT INTO "public"."college" VALUES ('40','10056','天津大学','http://www.etju.com/',null);

INSERT INTO "public"."college" VALUES ('41','10610','四川大学','http://www.scude.cc/',null);

INSERT INTO "public"."college" VALUES ('42','西南大学',null);

INSERT INTO "public"."college" VALUES ('43','10614','电子科技大学','http://www.remotedu.com/',null);

INSERT INTO "public"."college" VALUES ('44','西南科技大学',null);

INSERT INTO "public"."college" VALUES ('45','10613','西南交通大学','http://www.xnjd.cn/Index_index.action',null);

INSERT INTO "public"."college" VALUES ('46','10422','山东大学','http://jxjw.sdns.wljy.sdu.edu.cn/mh',null);

INSERT INTO "public"."college" VALUES ('47','10183','吉林大学','http://dec.jlu.edu.cn/cms/webucation/index.htm',null);

INSERT INTO "public"."college" VALUES ('48','郑州大学',null);

INSERT INTO "public"."college" VALUES ('49','中南大学',null);

INSERT INTO "public"."college" VALUES ('50','中国传媒大学',null);

INSERT INTO "public"."college" VALUES ('52','四川农业大学',null);

INSERT INTO "public"."college" VALUES ('53','国家开放大学',null);

INSERT INTO "public"."college" VALUES ('54',' ','北京大学医学网络教育学院',null);

-- ----------------------------

-- Alter Sequences Owned By

-- ----------------------------

-- ----------------------------

-- Indexes structure for table college

-- ----------------------------

CREATE INDEX "idx_college_college_name" ON "public"."college" USING btree ("college_name");

-- ----------------------------

-- Primary Key structure for table college

-- ----------------------------

ALTER TABLE "public"."college" ADD PRIMARY KEY ("college_id");

1，将输出的PostgreSql语句输出的表结构和文本内容放在word上边，然后在使用Notepad++打开或者直接打开word文本

(1)将“public". 字段替换为空

(2)删除 nextval() 函数信息

(3)将COLLATE 替换为空

(4)将“”字符替换为mysql识别的·字符(~号电脑Esc下面的字符)

(5)将int4 替换为int(11)

(6)将default替换为空

(7)将创建表加上唯一 PRIMARY KEY (`表唯一ID`)

(8)将with(oids = false)替换为 ENGINE=InnoDB CHARSET=utf8;

这样，执行mysql语句就可以创建表了，然后在插入数据，你就可以为所欲为了！！！

同样，如何你想Mysql转换为PostgreSQL，逆向思维就可以了！！！