[size=medium] 最近要在会员后台也加上FOA域名转出功能,所以首先要创建一个表service_transferwhois。
在oracle中字段类型如下:[/size]
字段 类型
ID NUMBER(11)
CODE VARCHAR2(100)
DOMAIN_NAME VARCHAR2(300)
AGENT_CODE VARCHAR2(20)
TRANSFER_TYPE VARCHAR2(10)
TRANSFER_DATE1 DATE
TRANSFER_DATE2 DATE
TRANSFER_IP1 VARCHAR2(50)
TRANSFER_IP2 VARCHAR2(50)
ZHUCESHANG VARCHAR2(200)
SUOYOUREN VARCHAR2(500)
LIANXIREN VARCHAR2(500)
EMAIL VARCHAR2(200)
WHOIS CLOB
STATE VARCHAR2(10)
JIAMI VARCHAR2(200)
PASSWORD VARCHAR2(60)
UIN_CODE VARCHAR2(30)
MAIL_CONTENT CLOB
TRANSFER_NOTATIONS VARCHAR2(2000)
在mysql中创建表service_transferwhois:
[size=medium]执行之后,报出以下异常:[/size]
[size=medium]后来才知道mysql中没有clob类型。改为blob类型就可以了。[/size]
在oracle中字段类型如下:[/size]
字段 类型
ID NUMBER(11)
CODE VARCHAR2(100)
DOMAIN_NAME VARCHAR2(300)
AGENT_CODE VARCHAR2(20)
TRANSFER_TYPE VARCHAR2(10)
TRANSFER_DATE1 DATE
TRANSFER_DATE2 DATE
TRANSFER_IP1 VARCHAR2(50)
TRANSFER_IP2 VARCHAR2(50)
ZHUCESHANG VARCHAR2(200)
SUOYOUREN VARCHAR2(500)
LIANXIREN VARCHAR2(500)
EMAIL VARCHAR2(200)
WHOIS CLOB
STATE VARCHAR2(10)
JIAMI VARCHAR2(200)
PASSWORD VARCHAR2(60)
UIN_CODE VARCHAR2(30)
MAIL_CONTENT CLOB
TRANSFER_NOTATIONS VARCHAR2(2000)
在mysql中创建表service_transferwhois:
create table service_transferwhois (id bigint not null,code VARCHAR(100),DOMAIN_NAME VARCHAR(300),
AGENT_CODE VARCHAR(20),TRANSFER_TYPE VARCHAR(10),TRANSFER_DATE1 datetime,TRANSFER_DATE datetime,
TRANSFER_IP1 VARCHAR(50),TRANSFER_IP2 VARCHAR(50),ZHUCESHANG VARCHAR(200),SUOYOUREN VARCHAR(500),
LIANXIREN VARCHAR(500),EMAIL VARCHAR(200),WHOIS clob,state VARCHAR(10),JIAMI VARCHAR(200),
PASSWORD VARCHAR(60),UIN_CODE VARCHAR(30),MAIL_CONTENT clob,TRANSFER_NOTATIONS VARCHAR(2000),
PRIMARY KEY(id)
)
[size=medium]执行之后,报出以下异常:[/size]
[CREATE - 0 row(s), 0.000 secs] [Error Code: 1064, SQL State: 42000]
You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near 'clob,STATE VARCHAR(10),JIAMI VARCHAR(200),
PASSWORD VARCHAR(60),UIN_CODE VARCHA' at line 4
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
[size=medium]后来才知道mysql中没有clob类型。改为blob类型就可以了。[/size]