MySQL doen not yet support nested queries.
Jawad Khan wrote:
> server version 3.23.35
>
>
>> -----Original Message-----
>> From: Khan, Jawad [COLE:6S34:EXCH]
>> Sent: Thursday, June 28, 2001 1:13 PM
>> To: '[EMAIL PROTECTED]'
>> Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
>> as shown
>>
>> Hope you can find the problem in the following SQL command:
>>
>> delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
>> limit 1 ;
>>
>> raiseTime is of type BIGINT.
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
