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. Quote 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. Quote 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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.