hey guys can you help me with these?
lock data when someone using an update and unlock after or canceling an update.
thanks
PHP Unlock-Lock Technique using mysql
Moderator: General Moderators
-
jakeneuman
- Forum Newbie
- Posts: 10
- Joined: Mon Mar 01, 2010 3:12 am
Re: PHP Unlock-Lock Technique using mysql
MySQL handles table-level and row-level locking automatically. If you want table-level locking, use a MYISAM storage engine, for row-level locking use a INNODB storage engine.
It sounds like row-level locking is what you are looking for.
It sounds like row-level locking is what you are looking for.
-
jakeneuman
- Forum Newbie
- Posts: 10
- Joined: Mon Mar 01, 2010 3:12 am
Re: PHP Unlock-Lock Technique using mysql
yup its row-level locking that i am looking for. btw, what is the use of INNODB?