表结构如下:create table cbankinterest ( workdate varchar(8) not null, bankid varchar(12) not null, product decimal(15,2) default 0.00 not null, interrest_rates decimal(15,2) default 0.000000 not null, interest decimal(15,2) ); create unique index cbankinterest_idx1 on cbankinterest (workdate,bankid);
执行update cbankinterest set bankid='235013053027' where bankid='133013051003' DB20134E The command was processed as an SQL statement because it was not a valid Command Line Processor command .During SQL processing it returned: SQL0803N One or more values in the INSER statement ,UPDATE statement ,or foreign key update caused by a DELETE statement are not valid because the table "IDDS.CBANKINTEREST" from having duplicate values for the index key. SQLSTATE=23505 求助此问题如何处理