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]
