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

Sending an SMS Message with ASP.NET
Often times it may be a requirement for your web application to send an SMS message. Such examples w

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

Call Screen statement Error
Dear Experts,

is there any setting that needs to be done before creating any dialog progr

How can use this array as a key?
Say I have this array for example:


print_r($array);

Prints:
Code: [Select]Array

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from

How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.

I'm using gamecanvas and I was thinking t

GMail like Chat in ASP.NET
Hi,Can anyone suggest me, how to incorporate GMail like chat in my existing ASP.Net application.I wa