You can use replace command instead of insert. It will handle duplicate rows.
Regards, Laercio. -----Original Message----- From: aman [mailto:[EMAIL PROTECTED] Sent: quarta-feira, 21 de julho de 2004 13:01 To: [EMAIL PROTECTED] Subject: RE: insertion of multiple rows I agree with Andrew - this is quicker. And if you area transferring data from one table to the other, you may wanna look at http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html Thanks Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 10:51, Andrew Hill wrote: > Hi Bruce, > > You might be interested in the LOAD DATA INFILE syntax. See > http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html. > > The command can either be used to replace duplicate records on unique > keys, or can ignore them. > > Cheers, > > -- > Andrew Hill > Developer > Awarez Ltd. > Kirkman House, 12-14 Whitfield Street, London W1T 2RF > T: +44 (0)20 7299 7370 F: +44 (0)20 7299 7374 > > ---------------------------------------------------------------------- > The information in this email is confidential and is intended solely > for the addressee. It may be legally privileged. The contents are not > to be disclosed to anyone other than the addressee and access to this > email by anyone else is unauthorised. > Unauthorised recipients are requested to preserve the confidentiality > of this email and to advise the sender immediately of any error in > transmission. Any disclosure, copying, distribution or action taken or > omitted to be taken in reliance upon the contents of this email by > unauthorised recipients is prohibited and may be unlawful. > ---------------------------------------------------------------------- > > > -----Original Message----- > > From: bruce [mailto:[EMAIL PROTECTED] > > Sent: 21 July 2004 16:36 > > To: [EMAIL PROTECTED] > > Subject: insertion of multiple rows > > > > 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?? 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??? > > > > thanks > > > > -bruce > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
