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?