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
>
> > -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
6: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 t
"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
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 duplic
