MySQL - Apply a row level lock using mysqli?

If you want to lock a specific row from editing, use FOR UPDATE at the end of a SELECT query. This locks the row in your transaction and prevents other users from updating it. This only works in transactional storage engines like innodb in answer to your questions, yes, row level locks "stop anyone editing currently present rows that match your criteria".

More specifically, if (inside a transaction) you INSERT, UPDATE or DELETE a row, that row is locked from editing by anyone else until your COMMIT your transaction. If you SELECT a row using FOR UPDATE then that also locks the row however, this does not "stop a user inserting a row which matches your criteria.

If you want to lock a specific row from editing, use FOR UPDATE at the end of a SELECT query. This locks the row in your transaction and prevents other users from updating it. This only works in transactional storage engines like innodb.In answer to your questions, yes, row level locks "stop anyone editing currently present rows that match your criteria".

More specifically, if (inside a transaction) you INSERT, UPDATE or DELETE a row, that row is locked from editing by anyone else until your COMMIT your transaction. If you SELECT a row using FOR UPDATE then that also locks the row. However, this does not "stop a user inserting a row which matches your criteria".

It should be stressed that row level locking is only available in InnoDB and not MyISAM. – Greg K Nov 13 '09 at 16:22 Ah, just seen the innodb tag on this :) – Greg K Nov 13 '09 at 16:23.

The InnoDB engine uses row level locking but this is an automatic internal MySQL process.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.