RE: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown (a correction)

[Jawad Khan]

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.