Error แบบนี้แก้ไขยังไรครับ ขึ้นตอนอัปเกรด structure
Clone table provis_diag -> tmp_provis_diag
Execute command add unique index ix_provis_unique (export_month,pid,seq,diagcode)
SQL Error: Duplicate entry '255201-006733-90418-Z480' for key 'ix_provis_unique'
Enabling keys
Synchronize table provis_diag
Synchronize row data done.
Rename table tmp_provis_diag --> provis_diag
Safe alter table done.
Safe alter table start for table provis_proced command add unique index ix_provis_unique (export_month,pid,seq,proced)
Install Trigger on provis_proced
Clone table provis_proced -> tmp_provis_proced
Execute command add unique index ix_provis_unique (export_month,pid,seq,proced)
SQL Error: Duplicate entry '255201-000000-90388-9999' for key 'ix_provis_unique'
Enabling keys
Synchronize table provis_proced
Synchronize row data done.
Rename table tmp_provis_proced --> provis_proced
Safe alter table done.
หัวข้อ: HOSxP 3.54.8.19 ออกแล้ว !!! (อ่าน 8363 ครั้ง)