0

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

2
Contributors
3
Replies
4
Views
10 Years
Discussion Span
Last Post by Dani
0

Hi cscgal,

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

Regards,
Mahe4us

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.