vidhya Posted October 18, 2008 Share Posted October 18, 2008 How to lock a mysql table while an insert or update operation is being done by a person so that the other person can only view but shd not be able to do any other operation until the former operation is completed. Pls help. Link to comment https://forums.phpfreaks.com/topic/128942-solved-locking-a-table-while-insert-operation-is-done/ Share on other sites More sharing options...
fenway Posted October 18, 2008 Share Posted October 18, 2008 Perhaps you should look at InnoDB ACID transactions. Link to comment https://forums.phpfreaks.com/topic/128942-solved-locking-a-table-while-insert-operation-is-done/#findComment-668701 Share on other sites More sharing options...
vidhya Posted October 23, 2008 Author Share Posted October 23, 2008 thanks for the reply. Am new to php and sql.Can u guide me on how to go with the innodb? thanks in advance Link to comment https://forums.phpfreaks.com/topic/128942-solved-locking-a-table-while-insert-operation-is-done/#findComment-672541 Share on other sites More sharing options...
fenway Posted October 23, 2008 Share Posted October 23, 2008 Not so simple... mysql has some great dev articles, that's a good place to start. Link to comment https://forums.phpfreaks.com/topic/128942-solved-locking-a-table-while-insert-operation-is-done/#findComment-673223 Share on other sites More sharing options...
vidhya Posted October 28, 2008 Author Share Posted October 28, 2008 thank you Link to comment https://forums.phpfreaks.com/topic/128942-solved-locking-a-table-while-insert-operation-is-done/#findComment-676357 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.