INSERT IGNORE INTO as Paul said will skip the duplicate values an
continue inserting, with a mutli row insert mysql will only skip the
duplicate values as the below example shows.
mysql> create table t (t int not null, unique index (t));
Query OK, 0 rows affected (0.02 sec)
mysql> desc t;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| t | int(11) | | PRI | 0 | |
+---+-+--+-+-+---+
1 row in set (0.01 sec)
mysql> insert into t (t) values (1), (2), (3);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> delete from t where t in(2, 3);
Query OK, 2 rows affected (0.01 sec)
mysql> insert ignore into t (t) values (1), (2), (3);
Query OK, 2 rows affected (0.00 sec)
Records: 3 Duplicates: 1 Warnings: 0
mysql> select * from t;
+---+
| t |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 rows in set (0.00 sec)
-Eric
On Fri, 3 Sep 2004 19:23:03 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 17:03 -0700 9/3/04, Mir Islam wrote:
> >Does anyone know mysql handles duplicate key handling during multi inserts?
> >
> >INSERT INTO test values(1,2),(3,4),(4,5),(1,6),(6,7);
> >
> >Now the above statement fails and gives duplicate key error and exits.
> >Is there a way for it to ignore the key violation and continue
> >processing the batch?
>
> INSERT IGNORE INTO ...
>
> --
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Eric Bergen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
