DROP TABLE HY_MTP_E;
Create table HY_MTP_E(
STCD CHAR(8) NOT NULL,
YR DEC(4) NOT NULL,
MTH DEC(2) NOT NULL,
P DEC(6,1),
PRCD CHAR(4),
PDYNUM DEC(2),
PDYNUMRCD CHAR(4));INSERT INTO HY_MTP_E(STCD,YR,MTH,P,PRCD,PDYNUM,PDYNUMRCD) VALUES('就是一些字符串');
每次把PDYNUMRCD CHAR(4)消掉之后就不报错 一加上PDYNUMRCD CHAR(4)就报错说最后一行列名'PDYNUMRCD'无效
求大家指教
Create table HY_MTP_E(
STCD CHAR(8) NOT NULL,
YR DEC(4) NOT NULL,
MTH DEC(2) NOT NULL,
P DEC(6,1),
PRCD CHAR(4),
PDYNUM DEC(2),
PDYNUMRCD CHAR(4));INSERT INTO HY_MTP_E(STCD,YR,MTH,P,PRCD,PDYNUM,PDYNUMRCD) VALUES('就是一些字符串');
每次把PDYNUMRCD CHAR(4)消掉之后就不报错 一加上PDYNUMRCD CHAR(4)就报错说最后一行列名'PDYNUMRCD'无效
求大家指教
(
STCD CHAR(8) NOT NULL ,
YR DEC(4) NOT NULL ,
MTH DEC(2) NOT NULL ,
P DEC(6, 1) ,
PRCD CHAR(4) ,
PDYNUM DEC(2) ,
PDYNUMRCD CHAR(4)
)
INSERT INTO HY_MTP_E(STCD,YR,MTH,P,PRCD,PDYNUM,PDYNUMRCD)
SELECT '',1,1,1,'',1,''
SELECT * FROM HY_MTP_E
/*
STCD YR MTH P PRCD PDYNUM PDYNUMRCD
1 1 1.0 1 */我这儿没啥问题。
--列名 '%1!' 无效。
select * from HY_MTP_E
看看有没有PDYNUMRCD这个列