4 messages in com.mysql.lists.perlRe: sql error
FromSent OnAttachments
Ravi Malghan28 Apr 2004 14:46 
Tobias Asplund28 Apr 2004 14:58 
Rudy Lippan28 Apr 2004 15:05 
Rudy Lippan28 Apr 2004 16:37 
Subject:Re: sql error
From:Rudy Lippan (rlip@remotelinux.com)
Date:04/28/2004 03:05:09 PM
List:com.mysql.lists.perl

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