Hi,

I have one doubt in mysql command using limit. I want to delete a first record in a table using mysql query. I using the below query

DELETE from view_me where member_id = '$sess' LIMIT 0,1

But if I used the above query mysql cannot deleted the record. It can deleted only if using the query like below.
DELETE from view_me where member_id = '$sess' LIMIT 1

My doubt why mysql can't delete the record if using the first query. Usually the limit offset is 0 for first record. Then ?

Thanks for all,
Please reply me if anybody have answer for this

Hi cscgal,

Thanks for your great reply. I have understood that we can't use offset in delete query. Thanks once again...

Regards,
Mahe4us

You're welcome.