Locking the row after reading

[Prasad Kavuri]

Dear all,

This is regarding locking the row after select statement.
Once the record was returned then it should lock until we perform update on that row.
So until updation no one should get that row as result of another query.

Configuration: Mysql-4.1.10, Table type : InnoDB

We have tried with Select for update, but no use.
my query is like this using select for update:
SELECT num FROM account_number FOR UPDATE;

This one is really not locking the row. Is there any way? Please help me.

Thanks in advance,

Kavuri.