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

2001-06-28 Thread 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 f

I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as sho wn

2001-06-28 Thread Jawad Khan
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.