postgresql 转 mysql_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, null, null, null);
INSERT INTO "public"."college" VALUES ('31', '10698', '西安交通大学', 'http://www.xjtudlc.com/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('32', '11414', '中国石油大学(北京)', 'http://www.cupde.cn/cms/fxlsy/index.htm', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('33', '10699', '西北工业大学', 'http://www.nwpunec.net/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('34', '11415', '中国地质大学(北京)', 'http://www.cugbonline.cn/info.do?columnId=249', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('35', '10718', '陕西师范大学', 'http://sde.snnu.edu.cn/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('36', '', '北京大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('37', '10030', '北京外国语大学', 'http://www.beiwaionline.com/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('38', '10008', '北京科技大学', 'http://cr.ustb.edu.cn/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('39', '10055', '南开大学', 'http://weo.nankai.edu.cn', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('40', '10056', '天津大学', 'http://www.etju.com/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('41', '10610', '四川大学', 'http://www.scude.cc/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('42', '', '西南大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('43', '10614', '电子科技大学', 'http://www.remotedu.com/', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('44', '', '西南科技大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('45', '10613', '西南交通大学', 'http://www.xnjd.cn/Index_index.action', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('46', '10422', '山东大学', 'http://jxjw.sdns.wljy.sdu.edu.cn/mh', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('47', '10183', '吉林大学', 'http://dec.jlu.edu.cn/cms/webucation/index.htm', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('48', '', '郑州大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('49', '', '中南大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('50', '', '中国传媒大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('52', '', '四川农业大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('53', '', '国家开放大学', '', null, null, null, null, null);
INSERT INTO "public"."college" VALUES ('54', ' ', '北京大学医学网络教育学院', ' ', null, null, null, null, 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，逆向思维就可以了！！！