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

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

Amatuer requiring assistance
Beginner and amateur in need of assistance

My Site - (Spare Parts for Domestic Appliances)

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

C++ Http request?
Code: string Response = "LOGIN_UNSUCCESSFUL"; System.Net.WebRequest request = Sy

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if