mysql一张表复制到另外一张表
insert into big_2 select * from big_4 报错
[23000][1062] Duplicate entry '1' for key 'big_2.PRIMARY' 看报错,是big_2的主键已经有1了,不能再插入相同的值,我这边id是自增字段,指定插入字段就能解决,调整下插入语句即可
insert into big_2(`name`, phone, idCard, random_1, random_2, random_3, create_time)
select `name`, phone, idCard, random_1, random_2, random_3, create_time from big_4; 去除id,指定其他插入字段即可
解决。


![[23000][1452] Cannot add or update a child row: a foreign key constraint fails (`test2`.`#sql-1238_5](https://img-blog.csdnimg.cn/8290f2862edd4b0384d8e3811d2b6f8c.gif)

![[23000][1062] Duplicate entry ‘6‘ for key ‘PRIMARY‘](https://img-blog.csdnimg.cn/dd6f11dc96204dccaaaac85d7085be65.gif)
![SQLSTATE[23000]: Integrity constraint violation:1062 Duplicate entry1664187678631531497821000‘ 解决办法](https://img-blog.csdnimg.cn/79832d39af8c43f2bf67e08f5da5ffd2.png)








