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

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 li