- 论坛徽章:
- 1
|
我在程序里面执行insert语句,但是报错,日志显示这样
save_lan_vnl][1844][query sql: "INSERT INTO LANVNL_20150916 (record_time, pool_id, node_id, lvnl_visits, lvnl_links) VALUES(70100, 2791, 4077, 0, 0),(70100, 3481, 8104, 0, 0),(70100, 3481, 4682, 0, 0),(70100, 3491, 4692, 0, 0),(70100, 9149, 160, 0, 0),(70100, 1188, 4076, 0, 0),(70100, 1188, 4077, 0, 0);" error: 1062: Duplicate entry '1' for key 'PRIMARY']
但是可以看到我是没有插入主键的,请问为什么会产生这个问题???
表结构:
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Defa | |
+-------------+------------------+------+-----+---------+----------------+
| lvnl_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| record_time | date | NO | MUL | NULL | |
| pool_id | int(10) unsigned | NO | | NULL | |
| node_id | int(10) unsigned | NO | | NULL | |
| lvnl_visits | int(10) unsigned | NO | | NULL | |
| lvnl_links | int(10) unsigned | NO | | NULL | |
| lvnu_item1 | int(10) unsigned | YES | | NULL | |
| lvnu_item2 | int(10) unsigned | YES | | NULL | |
| lvnu_item3 | int(10) unsigned | YES | | NULL | |
+-------------+------------------+------+-----+---------+----------------+
数据库版本
mysql Ver 14.14 Distrib 5.1.51, for pc-linux-gnu (x86_64) using readline 5.1
|
|