合 从ERROR 1062 (23000) at line Duplicate entry 'R01' for key 'PRIMARY' 能看出什么
Tags: MySQL
报错:
1 | ERROR 1062 (23000) ``at` `line 19632: Duplicate entry ``'G000001-hotel-pcid_auto'` `for` `key` `'PRIMARY'``ERROR 1062 (23000) ``at` `line 30155: Duplicate entry ``'R01'` `for` `key` `'PRIMARY'``ERROR 1062 (23000) ``at` `line 951: Duplicate entry ``'H000001-008X-%'` `for` `key` `'PRIMARY' |
解决:我们都知道,这个报错是主键重复的错误,但是,我们从这个报错能读出什么?
例如: