RE: Syntax question for a beginner..

[Bomber Steel]

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: Newbie problem with winmysqladmin

[Bomber Steel]

How did you get MySQL up and running on your PC?

I am trying to get MySQL running on my PC and I cannot find out how to even
start it. Is there an installation manual in the files? Is there a manual on
how to use MySQL in the files?

Bomber Steel

-Original Message-
From: Michael Tam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 1:28 PM
To: mysql
Subject: Newbie problem with winmysqladmin

Hi All,

I am new to MySQL and have a problem using winmysqladmin.  MySQL is
working fine, which I can access the database from my Java apps.  However,
when I tried to use winmysqladmin to obtain my db and table info,
winmysqladmin never connects with MySQL and I can't obtain the info.

In addition, beside winmysqladmin, what other gui program will allow me
to obtain those info?

If anybody can give me a direction to where I should look into, that
would be great and appreciated.

Thank you.

Best regards,
Michael Tam


-
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