mysql转oracle的方言_将ORACLE语句转换为Mysql语句

CREATETABLE"LXA"."USERS"("U_ID"NUMBER(*,0)NOTNULLENABLE,"U_NAME"VARCHAR2(50BYTE)NOTNULLENABLE,"U_PWD"VARCHAR2(50BYTE)NOTNULLENABLE,"U_IP"VARCHAR2(50BYTE),"U_STATE"VARCHAR...

CREATE TABLE "LXA"."USERS"(

"U_ID" NUMBER(*,0) NOT NULL ENABLE,

"U_NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,

"U_PWD" VARCHAR2(50 BYTE) NOT NULL ENABLE,

"U_IP" VARCHAR2(50 BYTE),

"U_STATE" VARCHAR2(50 BYTE),

"U_GENDER" VARCHAR2(50 BYTE),

"U_EMAIL" VARCHAR2(50 BYTE),

"U_LAST_LOGIN" DATE,

"U_LAST_EXIT" DATE,

"U_REMARKE" VARCHAR2(3000 BYTE),

"U_SIGNATURE" VARCHAR2(100 BYTE),

"U_HEAD_IMG" VARCHAR2(100 BYTE),

"U_TYPE" VARCHAR2(50 BYTE),

"U_BIRTHDAY" DATE,

CONSTRAINT "PK_USERS" PRIMARY KEY ("U_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE

)

SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(

INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT

)

TABLESPACE "USERS";

最后：类似下面这样的句子在MySQL中是否有？有的话又是怎样一个形式(怎么写)？

COMMENT ON COLUMN "LXA"."USERS"."U_ID" IS '用户ID';

这是其中一张表，由于两张表一起发超过了限制，所以分两次发吧。

后一个问题：

http://zhidao.baidu.com/question/578562678.html

展开