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]
