There is REPLACE... SELECT...
http://dev.mysql.com/doc/mysql/en/REPLACE.html
Thanks
Aman
On Wed, 2004-07-21 at 11:32, aman wrote:
> Replace will be useful if you mean to delete the previous duplicates and
> then enter the new data.
> Moreover there is no REPLACE... SELECT like there is INSERT...
e requisite information, and
> then delete the temp table...
>
> any thoughts...
>
> -bruce
>
>
> -Original Message-
> From: Andrew Hill [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 21, 2004 8:51 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject
Replace will be useful if you mean to delete the previous duplicates and
then enter the new data.
Moreover there is no REPLACE... SELECT like there is INSERT... SELECT
which make life easy!
Aman Raheja
http://www.techquotes.com
On Wed, 2004-07-21 at 11:12, Laercio Xisto Braga Cavalcanti wrote:
>
temp table...
any thoughts...
-bruce
-Original Message-
From: Andrew Hill [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 8:51 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: insertion of multiple rows
Hi Bruce,
You might be interested in the LOAD DATA INFILE syntax
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
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 migh
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 Str
"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
