[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: Parse error 1064 with subquery syntax using exists clause on wodows XP?
From:       "Markus Grossrieder" <markus.grossrieder () alba-systems ! com>
Date:       2004-07-23 8:46:26
Message-ID: 002001c47091$8c821280$6401a8c0 () ALBA ! DOM
[Download RAW message or body]

> My server version :  4.0.18-max-nt

>From the Fine Manual (http://dev.mysql.com/doc/mysql/en/Subqueries.html):

"Starting with MySQL 4.1, all subquery forms and operations that the SQL
standard requires are supported, as well as a few features that are
MySQL-specific."

=> upgrade to 4.1.x

----- Original Message ----- 
From: "nambi c" <hellonambi@yahoo.com>
To: <win32@lists.mysql.com>
Sent: Thursday, July 22, 2004 7:35 PM
Subject: Parse error 1064 with subquery syntax using exists clause on wodows XP?


> Hi,
>
> My server version :  4.0.18-max-nt
> My OS : Windows XP
>
> This is what I get when I do status command on mysql
> prompt.
>
> mysql> status;
> --------------
> mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
>
> Connection id:          3
> Current database:       perlclass
> Current user:           root@localhost
> SSL:                    Not in use
> Server version:         4.0.18-max-nt
> Protocol version:       10
> Connection:             localhost via TCP/IP
> Client characterset:    latin1
> Server characterset:    latin1
> TCP port:               3306
> Uptime:                 8 min 49 sec
>
>
> I have created 2 tables 'channels' and 'users' in my
> database. I can query these tables individually. I am
> trying to execute a query with 'exists' clause.
>
> mysql> select * from channels where exists (select *
> from users);
> ERROR 1064: You have an error in your SQL syntax.
> Check the manual that corresp
> onds to your MySQL server version for the right syntax
> to use near 'exists (sele
> ct * from users)' at line 1
>
>
> I am getting this syntax error message. The query
> seems perfect to me. Any clue what is happening? Help!
>
> -Nambi
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail is new and improved - Check it out!
> http://promotions.yahoo.com/new_mail
>
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=markus.grossrieder@alba-systems.com
>
>



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]