"bruce" <[EMAIL PROTECTED]> wrote on 21/07/2004 16:35:34:
> hi...
>
> quick question that i can't find an answer to. i have 500-100 rows of
data
> that need to be inserted. i can do it a row at a time.
>
> is there a way i can do the inserts all at one time, reducing the hits
on
> the database??
INSERT INTO table VALUES (a, b, c), (d, e, f), (g, h, i) ;
> and if i can do the inserts all at once, how do i handle
> possible duplicates if i have specified in the tbl design that the
element
> should be unique? would the insert bomb or continue???
It will bomb unless you add the keyword IGNORE, in which case it will
ignore the errors.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
