日期:2014-05-16  浏览次数:20643 次

让人无语的INSERT语句报错










但是




这又怎么解释呢??



解决方案是:

insert into CY_PROP_REASON select * from CY_PROP_REASON_INSERT;

这一句改成          
insert into CY_PROP_REASON(ID,	CREATETIME,	UPDATETIME,	VERSION,	BSC,	MO,	RESON_ATTRIBUTE,	FAULT_TYPE,	FAULT_TYPE2,	FAULT_LEVEL,	FAULT_OBJECT,	FAULT_DESCRIPTION,	TTIME,	THOUR,	REGION,	TOWN,	SUM_FLAG,	LABEL,	CH_RAT,	TOPN,	PRI,	CURRENT_INDEX_VALUE,	PI_COLUMN
)select ID,	CREATETIME,	UPDATETIME,	VERSION,	BSC,	MO,	RESON_ATTRIBUTE,	FAULT_TYPE,	FAULT_TYPE2,	FAULT_LEVEL,	FAULT_OBJECT,	FAULT_DESCRIPTION,	TTIME,	THOUR,	REGION,	TOWN,	SUM_FLAG,	LABEL,	CH_RAT,	TOPN,	PRI,	CURRENT_INDEX_VALUE,	PI_COLUMN
from CY_PROP_REASON_INSERT;