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?

No comments posted yet

Your Answer:

Login to answer
316 Like 54 Dislike
Previous forums Next forums
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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash