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]
both tableA and tableB, without the duplicates.
- Original Message -
From: "{ randy }" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 12:28
Subject: Syntax question for a beginner..
> Alright, I am about to pull my hair out.
.
Black Holes The End of The Universe?
John G. Taylor PG 11. Line 1
-Original Message-
From: { randy } [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 10:29 PM
To: MySQL
Subject: Syntax question for a beginner..
Alright, I am about to pull my hair out.
I have 2 tables. Each have
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
Alright, I am about to pull my hair out.
I have 2 tables. Each have a column 'email' that are unique. Some of the
records in both tables are duplicates and I want to combine the two tables
into one with out bringing in the duplicates. So...
I have this statement:
Mysql> SELECT email FROM tableA
