Re: Syntax question for a beginner..
Well, if you are combining the 2 tables like that into 1, then there is an
easier way without the need for an array.
Make sure you have a unique index on email for tableA and then
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 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, and thought I could
lick
it with just one query...not so. I guess nested selects can be done in
mssql. Anyway, here is what I did...basically:
SELECT tableA.email FROM tableA,tableB WHERE tableA.email = tableB.email;
Loaded that into an array[email]
Looped
DELETE FROM tableA WHERE email LIKE 'array[email]';
Then
SELECT email FROM tableA; # into another array[email]
Then
Looped
INSERT INTO tableB (id, email) VALUES('','array[email]');
That should do it I think
Thanks for the help though...now I know 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]
Subject: Re: Syntax question for a beginner..
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 available yet either. The next best
thing
that I can think of is to create a temporary table with the email column
having a unique index and first add the contents of tableA and then
tableB.
Finally, you can then retrieve all values from the temporary table which
contains all values from 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.
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 WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but
I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Syntax question for a beginner..
You are the man...thanks a bunch! that's what I needed.
=
r a n d y / sesser at mac.com
From: Rolf Hopkins [EMAIL PROTECTED]
Date: Fri, 6 Jul 2001 14:39:59 +0800
To: { randy } [EMAIL PROTECTED], MySQL [EMAIL PROTECTED]
Subject: Re: Syntax question for a beginner..
Well, if you are combining the 2 tables like that into 1, then there is an
easier way without the need for an array.
Make sure you have a unique index on email for tableA and then
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 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, and thought I could
lick
it with just one query...not so. I guess nested selects can be done in
mssql. Anyway, here is what I did...basically:
SELECT tableA.email FROM tableA,tableB WHERE tableA.email = tableB.email;
Loaded that into an array[email]
Looped
DELETE FROM tableA WHERE email LIKE 'array[email]';
Then
SELECT email FROM tableA; # into another array[email]
Then
Looped
INSERT INTO tableB (id, email) VALUES('','array[email]');
That should do it I think
Thanks for the help though...now I know 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]
Subject: Re: Syntax question for a beginner..
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 available yet either. The next best
thing
that I can think of is to create a temporary table with the email column
having a unique index and first add the contents of tableA and then
tableB.
Finally, you can then retrieve all values from the temporary table which
contains all values from 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.
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 WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but
I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Syntax question for a beginner..
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 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 WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Syntax question for a beginner..
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 2001 16:39:47 +1200
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 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 WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Syntax question for a beginner..
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.
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 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 WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Syntax question for a beginner..
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 available yet either. The next best thing
that I can think of is to create a temporary table with the email column
having a unique index and first add the contents of tableA and then tableB.
Finally, you can then retrieve all values from the temporary table which
contains all values from 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.
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 WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
