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)

;

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