Kishor,
>Hi,
>
>We are trying to implement row level locking in our appln.
>we have a table Orderwe are locking the table using
>SELECT * FROM Order FOR UPDATE;
>but still another user is able to update this table. why?
check with
mysql>SHOW TABLE STATUS FROM yourdatabasename;
that you
Hi,
We are trying to implement row level locking in our appln.
we have a table Order
we are locking the table using
SELECT * FROM Order FOR UPDATE;
but still another user is able to update this table. why?
we have autocommit set to zero.
Our requirement is
1. user selects a order for
