NYCPHP Meetup

NYPHP.org

What's wrong with this query.

Nasir Zubair nasir at nasir.us
Wed Mar 12 19:34:45 EST 2003

Previous message: [nycphp-talk] selecting/deleting all oldest entries in mysql.
Next message: [nycphp-talk] selecting/deleting all oldest entries in mysql.
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all,

Can anyone point out what is wrong with this query:

DELETE FROM `nsr_staffips` WHERE `tech` LIKE 'Nasir' ORDER BY `timestamp`
LIMIT 1 

According to mySQL manual it should delete the oldest entry ordered by the
timestamp filed.

- Nasir

Previous message: [nycphp-talk] selecting/deleting all oldest entries in mysql.
Next message: [nycphp-talk] selecting/deleting all oldest entries in mysql.
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the talk mailing list