没oracle基础,下面三张表请人帮忙"翻译"成MySQL:
1:
prompt PL/SQL Developer import file
prompt Created on 2011年8月22日 by Administrator
set feedback off
set define off
prompt Creating CT_SYSTEMCONST...
create table CT_SYSTEMCONST
(
ID NUMBER(19) not null,
LB NUMBER(10) not null,
LBMC VARCHAR2(50) not null,
MS VARCHAR2(300),
DM NUMBER(10) not null,
XGRQ DATE not null,
JSID NUMBER(19) not null,
FVALUE NUMBER,
IVALUE NUMBER(10),
DVALUE DATE,
CVALUE VARCHAR2(2000),
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
)
tablespace JYDB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index GUID_INDEX_SYN1 on CT_SYSTEMCONST (GUID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_CT_SYSTEMCONST on CT_SYSTEMCONST (LB, DM)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_CT_SYSTEMCONST_JSID on CT_SYSTEMCONST (JSID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index PK_CT_SYSTEMCONST on CT_SYSTEMCONST (ID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);2:
prompt PL/SQL Developer import file
prompt Created on 2011年8月22日 by Administrator
set feedback off
set define off
prompt Creating QT_TRADINGDAYNEW...
create table QT_TRADINGDAYNEW
(
ID NUMBER(18) not null,
TRADINGDATE DATE not null,
IFTRADINGDAY NUMBER(10),
SECUMARKET NUMBER(10),
IFWEEKEND NUMBER(10),
IFMONTHEND NUMBER(10),
IFQUARTEREND NUMBER(10),
IFYEAREND NUMBER(10),
XGRQ DATE not null,
JSID NUMBER(18) not null,
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
)
tablespace JYDB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_QT_TRADINGDAYNEW on QT_TRADINGDAYNEW (TRADINGDATE, SECUMARKET)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_QT_TRADINGDAYNEW_JSID on QT_TRADINGDAYNEW (JSID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index PK_QT_TRADINGDAYNEW on QT_TRADINGDAYNEW (ID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);3:prompt PL/SQL Developer import file
prompt Created on 2011年8月22日 by Administrator
set feedback off
set define off
prompt Creating SECUMAIN...
create table SECUMAIN
(
ID NUMBER(19) not null,
INNERCODE NUMBER(10) not null,
COMPANYCODE NUMBER(10),
SECUCODE VARCHAR2(10),
CHINAME VARCHAR2(200),
CHINAMEABBR VARCHAR2(100),
ENGNAME VARCHAR2(200),
ENGNAMEABBR VARCHAR2(50),
SECUABBR VARCHAR2(20),
CHISPELLING VARCHAR2(10),
SECUMARKET NUMBER(10),
SECUCATEGORY NUMBER(10),
LISTEDDATE DATE,
LISTEDSECTOR NUMBER(10),
LISTEDSTATE NUMBER(10),
XGRQ DATE not null,
JSID NUMBER(19) not null,
ISIN VARCHAR2(20),
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
)
tablespace JYDB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index GUID_INDEX_SYN32 on SECUMAIN (GUID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_SECUMAIN on SECUMAIN (INNERCODE)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_SECUMAIN_JSID on SECUMAIN (JSID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index PK_SECUMAIN on SECUMAIN (ID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
特别是RAWTOHEX(SYS_GUID()) 这个默认值的函数怎么转.
1:
prompt PL/SQL Developer import file
prompt Created on 2011年8月22日 by Administrator
set feedback off
set define off
prompt Creating CT_SYSTEMCONST...
create table CT_SYSTEMCONST
(
ID NUMBER(19) not null,
LB NUMBER(10) not null,
LBMC VARCHAR2(50) not null,
MS VARCHAR2(300),
DM NUMBER(10) not null,
XGRQ DATE not null,
JSID NUMBER(19) not null,
FVALUE NUMBER,
IVALUE NUMBER(10),
DVALUE DATE,
CVALUE VARCHAR2(2000),
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
)
tablespace JYDB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index GUID_INDEX_SYN1 on CT_SYSTEMCONST (GUID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_CT_SYSTEMCONST on CT_SYSTEMCONST (LB, DM)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_CT_SYSTEMCONST_JSID on CT_SYSTEMCONST (JSID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index PK_CT_SYSTEMCONST on CT_SYSTEMCONST (ID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);2:
prompt PL/SQL Developer import file
prompt Created on 2011年8月22日 by Administrator
set feedback off
set define off
prompt Creating QT_TRADINGDAYNEW...
create table QT_TRADINGDAYNEW
(
ID NUMBER(18) not null,
TRADINGDATE DATE not null,
IFTRADINGDAY NUMBER(10),
SECUMARKET NUMBER(10),
IFWEEKEND NUMBER(10),
IFMONTHEND NUMBER(10),
IFQUARTEREND NUMBER(10),
IFYEAREND NUMBER(10),
XGRQ DATE not null,
JSID NUMBER(18) not null,
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
)
tablespace JYDB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_QT_TRADINGDAYNEW on QT_TRADINGDAYNEW (TRADINGDATE, SECUMARKET)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_QT_TRADINGDAYNEW_JSID on QT_TRADINGDAYNEW (JSID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index PK_QT_TRADINGDAYNEW on QT_TRADINGDAYNEW (ID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);3:prompt PL/SQL Developer import file
prompt Created on 2011年8月22日 by Administrator
set feedback off
set define off
prompt Creating SECUMAIN...
create table SECUMAIN
(
ID NUMBER(19) not null,
INNERCODE NUMBER(10) not null,
COMPANYCODE NUMBER(10),
SECUCODE VARCHAR2(10),
CHINAME VARCHAR2(200),
CHINAMEABBR VARCHAR2(100),
ENGNAME VARCHAR2(200),
ENGNAMEABBR VARCHAR2(50),
SECUABBR VARCHAR2(20),
CHISPELLING VARCHAR2(10),
SECUMARKET NUMBER(10),
SECUCATEGORY NUMBER(10),
LISTEDDATE DATE,
LISTEDSECTOR NUMBER(10),
LISTEDSTATE NUMBER(10),
XGRQ DATE not null,
JSID NUMBER(19) not null,
ISIN VARCHAR2(20),
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
)
tablespace JYDB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index GUID_INDEX_SYN32 on SECUMAIN (GUID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_SECUMAIN on SECUMAIN (INNERCODE)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index IX_SECUMAIN_JSID on SECUMAIN (JSID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index PK_SECUMAIN on SECUMAIN (ID)
tablespace JYDB_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
特别是RAWTOHEX(SYS_GUID()) 这个默认值的函数怎么转.
这个字段:
GUID VARCHAR2(32) default RAWTOHEX(SYS_GUID())
默认值的设置.不知道这个在mysql如何实现.