mysql的insert问题

mysql的表设置了3个联合主键
插入的数据中有很多相同的数据
但是还是insert成功了，返回true了
这种情况正常吗？

解决方案 »

  1.   

    贴一组你认为是相同的记录。
    另外把 show create table 语句也贴出来。不太相信你所说的是真的。
      

  2.   

    如2楼所说，
    所以改用 insert into where not exists 语句
      

  3.   

    string query_str = "insert into " + table_name + "(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)"; query_str = query_str + "values(" + shipment_item.shipmentUin + "," + shipment_item.shipmentID +  "," + "'"
    + shipment_item.shipmentTime + "'" + "," + shipment_item.AppID +  "," + shipment_item.shipmentQuentity 
    + "," + "'" + shipment_item.shipmentIP + "'" + ")"; rtn_flag = mysql_query(&conn, query_str.c_str()); if(rtn_flag){
    count++;
    cout << "成功插入了第" << count << "条数据！" << endl;
    }以上是代码，有20条数据，每条数据都有10个重复的，执行之后全部都显示成功的了
      

  4.   

     show create table  xxx
    query_str内容是什么
      

  5.   

    string query_str = "insert into " + table_name + "(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)"; query_str = query_str + "values(" + shipment_item.shipmentUin + "," + shipment_item.shipmentID +  "," + "'"
    + shipment_item.shipmentTime + "'" + "," + shipment_item.AppID +  "," + shipment_item.shipmentQuentity 
    + "," + "'" + shipment_item.shipmentIP + "'" + ")"; rtn_flag = mysql_query(&conn, query_str.c_str()); if(rtn_flag){
    count++;
    cout << "成功插入了第" << count << "条数据！" << endl;
    }以上是代码，有20条数据，每条数据都有10个重复的，执行之后全部都显示成功的了
    不要贴PHP代码，毕竟这不是所有人在数据库都熟悉其它程序语言的。直接到你的MYSQL数据库找出你认为是 相同的记录。
      

  6.   


    string query_str = "insert into " + table_name + "(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)"; query_str = query_str + "values(" + shipment_item.shipmentUin + "," + shipment_item.shipmentID +  "," + "'"
    + shipment_item.shipmentTime + "'" + "," + shipment_item.AppID +  "," + shipment_item.shipmentQuentity 
    + "," + "'" + shipment_item.shipmentIP + "'" + ")"; rtn_flag = mysql_query(&conn, query_str.c_str()); if(rtn_flag){
    count++;
    cout << "成功插入了第" << count << "条数据！" << endl;
    }以上是代码，有20条数据，每条数据都有10个重复的，执行之后全部都显示成功的了
    不要贴PHP代码，毕竟这不是所有人在数据库都熟悉其它程序语言的。直接到你的MYSQL数据库找出你认为是 相同的记录。
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1131826560,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1650715360,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable14(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1009267102,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable7(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1482635863,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into (shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(2283645654,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable1(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(857585569,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable10(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1014521322,540010002,'2013-07-07 07:00:00',1002,131989513,'10.187.133.174')
    insert into expresssucshipmenttable8(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1464055960,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable11(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(727393163,540010002,'2013-07-07 07:00:00',1002,131989513,'10.187.136.23')
    insert into expresssucshipmenttable10(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(990592170,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable5(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1348658389,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(812184336,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into (shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(2320572604,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable7(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1634516231,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable9(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(824611081,540010002,'2013-07-07 07:00:00',1002,131989514,'10.187.133.176')
    insert into expresssucshipmenttable9(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1936930009,540010002,'2013-07-07 07:00:00',1002,131989514,'10.187.133.165')
    insert into expresssucshipmenttable12(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(707604076,540010002,'2013-07-07 07:00:00',1002,131989509,'10.187.136.25')
    insert into expresssucshipmenttable12(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(991800412,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable6(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(173519638,540010002,'2013-07-07 07:00:00',1002,131989511,'10.187.133.171')
    insert into expresssucshipmenttable2(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(990087346,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1131826560,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1650715360,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable14(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1009267102,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable7(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1482635863,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into (shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(2283645654,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable1(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(857585569,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable10(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1014521322,540010002,'2013-07-07 07:00:00',1002,131989513,'10.187.133.174')
    insert into expresssucshipmenttable8(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1464055960,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable11(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(727393163,540010002,'2013-07-07 07:00:00',1002,131989513,'10.187.136.23')
    insert into expresssucshipmenttable10(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(990592170,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable5(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1348658389,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(812184336,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into (shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(2320572604,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable7(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1634516231,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable9(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(824611081,540010002,'2013-07-07 07:00:00',1002,131989514,'10.187.133.176')
    insert into expresssucshipmenttable9(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1936930009,540010002,'2013-07-07 07:00:00',1002,131989514,'10.187.133.165')
    insert into expresssucshipmenttable12(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(707604076,540010002,'2013-07-07 07:00:00',1002,131989509,'10.187.136.25')
    insert into expresssucshipmenttable12(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(991800412,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable6(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(173519638,540010002,'2013-07-07 07:00:00',1002,131989511,'10.187.133.171')
    insert into expresssucshipmenttable2(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(990087346,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
      

  7.   

    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1131826560,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1650715360,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert into expresssucshipmenttable14(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1009267102,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')
    insert 主键是什么？
    然后随便找出两条你认为是重复的记录即可.
      

  8.   


    insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1131826560,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')insert into expresssucshipmenttable0(shipmentUin,shipmentID,shipmentTime,shipmentChannel,shipmentQuantity,shipmentIP)values(1131826560,113100100,'2013-07-07 07:00:00',131,1,'0.0.0.0')我上面贴了40行语句，就在第1行和第21行
    分了16张表，不过他们的结构完全一样，字段为：
    shipmentUin int 主键1
    shipmentID  int 主键2
    shipmentTime datetime 主键3
    shipmentChannel int 
    shipmentQuantity int
    shipmentIP  varchar(20)