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
展开