`

让人无语的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;


  • 大小: 26.3 KB
  • 大小: 93.9 KB
  • 大小: 93.5 KB
  • 大小: 37.3 KB
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics