CLOB 不要加字段长度
MSN:zhoujianguo_leo@hotmail.com
CREATE TABLE kh_qzpsxx (
ID integer NOT NULL,
khbh varchar(64) WITH DEFAULT null ,
psxx CLOB WITH DEFAULT null ,
psr varchar(64) WITH DEFAULT null ,
shr varchar(64) WITH DEFAULT null ,
pszt varchar(64) WITH DEFAULT null ,
shyj varchar(512) WITH DEFAULT null ,
psrq timestamp WITH DEFAULT NULL,
shrq timestamp WITH DEFAULT NULL,
nf integer NOT NULL,
qs integer WITH DEFAULT NULL,
fs float(32) NOT NULL,
pslx varchar(64) WITH DEFAULT null
)
MSN:zhoujianguo_leo@hotmail.com
CREATE TABLE kh_qzpsxx (
ID integer NOT NULL,
khbh varchar(64) WITH DEFAULT null ,
psxx CLOB WITH DEFAULT null ,
psr varchar(64) WITH DEFAULT null ,
shr varchar(64) WITH DEFAULT null ,
pszt varchar(64) WITH DEFAULT null ,
shyj varchar(512) WITH DEFAULT null ,
psrq timestamp WITH DEFAULT NULL,
shrq timestamp WITH DEFAULT NULL,
nf integer NOT NULL,
qs integer WITH DEFAULT NULL,
fs float(32) NOT NULL,
pslx varchar(64) WITH DEFAULT null
)