[img]http://dl2.iteye.com/upload/attachment/0094/6661/00e763df-76bb-3483-9ba0-8ad85606079e.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0094/6663/4f86e578-1e25-367d-9b36-8abcca7baeb1.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0094/6665/3bcf8330-a95e-33a1-b360-8109c6e5365b.jpg[/img]
但是
[img]http://dl2.iteye.com/upload/attachment/0094/6667/93bebe65-0d08-3be7-9c78-5f843771b588.jpg[/img]
这又怎么解释呢??
[img]http://dl2.iteye.com/upload/attachment/0094/6663/4f86e578-1e25-367d-9b36-8abcca7baeb1.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0094/6665/3bcf8330-a95e-33a1-b360-8109c6e5365b.jpg[/img]
但是
[img]http://dl2.iteye.com/upload/attachment/0094/6667/93bebe65-0d08-3be7-9c78-5f843771b588.jpg[/img]
这又怎么解释呢??
解决方案是:
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;