Page 1 of 1
PHP Unlock-Lock Technique using mysql
Posted: Sat Mar 13, 2010 1:18 am
by jakeneuman
hey guys can you help me with these?
lock data when someone using an update and unlock after or canceling an update.
thanks
Re: PHP Unlock-Lock Technique using mysql
Posted: Sat Mar 13, 2010 6:55 am
by AlanG
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.
Re: PHP Unlock-Lock Technique using mysql
Posted: Sun Mar 14, 2010 6:34 pm
by jakeneuman
yup its row-level locking that i am looking for. btw, what is the use of INNODB?