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

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

PHP submit form script causing blank page
Im trying to submit a form using this script, however nothing shows up on the page, does anyone know

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website