gt; INSERT INTO tableA(email) SELECT email FROM tableB
>
> The unique index will stop the duplication while adding values that are in B
> but not in A.
>
> - Original Message -
> From: "{ randy }" <[EMAIL PROTECTED]>
> To: "MySQL" <[EMAIL PRO
that are in B
but not in A.
- Original Message -
From: "{ randy }" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 14:05
Subject: Re: Syntax question for a beginner..
> Well, I think I got it figured out. I am using PHP,
ow you can't do nested selects :\
- randy
=
r a n d y / sesser at mac.com
> From: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Date: Fri, 6 Jul 2001 13:57:27 +0800
> To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL" <[EMAIL PROTECTED]
Even if sub-selects were available in MySQL (which they're not), that query
would still not work as it will only select the values that are unique to
tableA.
What you would be looking at is something like:
SELECT email
FROM tableA
UNION
SELECT email
FROM tableB
But unfortunately, UNION is not a
I am a rookie as well so this may not work but I think it should. Could you
not just copy all of one into the other and then select all out of it using
DISTINCT so you get no duplicates out of it?
Bomber Steel
Mankind has, ever since it began to think,
worshipped that which it cannot understand.
I had never seen "WHERE NOT" before.
Does this exist in mysql
siomara
>From: Shania Qiu <[EMAIL PROTECTED]>
>To: '{ randy }' <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: RE: Syntax question for a beginner..
>Date: Fri, 6 Jul
I remember somewhere has mentioned that MySQL does not copy with nested
SELECT query. Properly it is the reason.
Shania Qiu
-Original Message-
From: { randy } [mailto:[EMAIL PROTECTED]]
Sent: Friday, 6 July 2001 4:29 p.m.
To: MySQL
Subject: Syntax question for a beginner..
Alright, I
