Re: PROBLEMS WITH DELETE

2003-12-28 Thread Victoria Reznichenko
Tomas Isakowitz [EMAIL PROTECTED] wrote: 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

PROBLEMS WITH DELETE

2003-12-26 Thread 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