----- Original Message ----- From: "Ravi Malghan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 28, 2004 6:34 PM Subject: sql error
Hi: I am building perl scripts which can insert data into a database independent of the type of database. The following query works in postgresql, but I am getting the following error when I run sql query in mysql 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) I am using 4.0.18-standard binary. Any ideas? Does this version support subselects. In a word, no. Subselects are not supported in MySQL until version 4.1.x. This is currently available in alpha mode and I hear it is working pretty well for most people but don't know if you want to take the plunge and try it. Otherwise, you'll need to rewrite your query for MySQL. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]