sql error

am 28.04.2004 23:47:15 von Ravi Malghan

------=_NextPart_000_02A6_01C42D48.D80C3370
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi: I am getting the following error when I run sql query

mysql> SELECT ipaddress FROM ip_via_pingsweep WHERE ipaddress NOT IN =
(SELECT ipaddress FROM object_subips);
ERROR 1064: You have an error in your SQL syntax. Check the manual that =
corresponds to your MySQL server version for the right syntax to use =
near 'SELECT ipaddress FROM object_subips)' at line 1

The following 2 queries are fine:
mysql> select ipaddress FROM ip_via_pingsweep;
Empty set (0.00 sec)

mysql> SELECT ipaddress FROM object_subips;
Empty set (0.00 sec)

Any ideas?

TIA
Ravi
------=_NextPart_000_02A6_01C42D48.D80C3370--

Re: sql error

am 28.04.2004 23:59:21 von Tobias Asplund

On Wed, 28 Apr 2004, Rudy Lippan wrote:

> On Wed, 28 Apr 2004, Ravi Malghan wrote:
>
> > ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ipaddress FROM object_subips)' at line 1
> >
>
> Probably because you are using mysql 4.x wich does not support subselects.

4.0.x does not, 4.1+ does support subqueries.

Cheers,
Tobias

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: sql error

am 28.04.2004 23:59:21 von Tobias Asplund

Re: sql error

am 29.04.2004 00:05:31 von Rudy Lippan

On Wed, 28 Apr 2004, Ravi Malghan wrote:

> Hi: I am getting the following error when I run sql query
>

This does not have much to do with perl :-) You might want to try on a more
general list.

> mysql> SELECT ipaddress FROM ip_via_pingsweep WHERE ipaddress NOT IN (SELECT ipaddress FROM object_subips);
> ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ipaddress FROM object_subips)' at line 1
>

Probably because you are using mysql 4.x wich does not support subselects.

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: sql error

am 29.04.2004 00:05:31 von Rudy Lippan

Re: sql error

am 29.04.2004 01:38:10 von Rudy Lippan

On Wed, 28 Apr 2004, Tobias Asplund wrote:

> On Wed, 28 Apr 2004, Rudy Lippan wrote:
>
> > On Wed, 28 Apr 2004, Ravi Malghan wrote:
> >
> > > ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ipaddress FROM object_subips)' at line 1
> > >
> >
> > Probably because you are using mysql 4.x wich does not support subselects.
>
> 4.0.x does not, 4.1+ does support subqueries.
>

Yes. That is what I meant 4.0.x.

Bad, bad fingers.

Thank you,

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: sql error

am 29.04.2004 01:38:10 von Rudy Lippan