Simultaneous select/update/insert

Posted on 16th Feb 2014 07:03 pm by admin

Hi

How would I need to go about when 2 users update a single row simultaneous? And how would I need to go about when 2 users want to edit a row?

Should I first lock the table, update the row to indicate who is editing the data unlocking the table and selecting the row where the editor_id = the current user_id? Plus what happens when I lock the table do other users get a failed query? and what errno does mysql return in this case?

Do I need to use not null on required fields or should I leave it out?

Your Answer:

Login to answer

Other forums

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

OPINIONS WANTED
This is my login page code, and I want your opinion on it please!

Code: // Login ~ CHECKS

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */

Load Animated Image while cache is serve
I have a page that loads up using cache and took about 1 to 2 minutes before it loads to the page. <

Character increment
Hi,

I am facing a scenario like above,but in my case i want to show up like Col A,Col B etc..

IS Retail & Manufacturing
Hi

Can IS Retail and Manufacturing activities be done in same instance ie. in same client

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

MS Exchange 2007 integration with ECC 6.0
Hello Experts,
We have ECC 6.0 and MS Exchange 2007. We need to integrate ECC 6 and MS Excha

How to file_get_contents when login required?
Hello!

I am trying to read data from a page that you have to be logged into to view, I am try