How can i lock row in database?

bhawin13 · #1 (**permalink**) 04-17-04, 08:22

How to lock row for operation so other operation can not read that row.

I want to maintain concurrency. is there any way to lock row?
Is mysql support row level locking?
If yes how?

ika · #2 (**permalink**) 04-17-04, 08:26

Quote:

Originally posted by bhawin13
How to lock row for operation so other operation can not read that row.

I want to maintain concurrency. is there any way to lock row?
Is mysql support row level locking?
If yes how?

Yes, MySQL supports row level locking but you need to use InnoDB database engine.

FYI: locking is not for select queries but it prevents DML queries!

Pat Phelan · #3 (**permalink**) 04-17-04, 13:04

I suspect that this question is related to another question you posted. Which database engine are you using?

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech