PROBLEMS WITH DELETE

[Tomas Isakowitz]

The following query does not work. It fits the exact format of DELETE in 
the documentation.

DELETE from price WHERE ticker ='MSFT' ORDER BY date DESC LIMIT 3;

I am trying to delete the most recent 3 records. I get an error "You 
have an error in your SQL syntax near 'ORDER BY date LIMIT 3' at line 1"

If I take the "ORDER BY date" portion, the query works OK. The problem 
is that this is not what I need.

Anyone  out there knows what is going on?

Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]