List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 29 2001 1:07pm
Subject:Re: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as
shown (a correction)
View as plain text  
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:	'mysql@stripped'
>> 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
gerald_clark@stripped

Thread
RE: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown (a correction)Jawad Khan28 Jun
  • Re: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown (a correction)Gerald Clark29 Jun