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

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date t

Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file

classic dynpro : hide area and auto adjust hights
Hi,

I want to develop a similar user interface as is used in standard transaction MIGO.

Mail sending is slow on server
Why mail is taking time to be send on apache-linux server

media recovery
Hi,
i startup the database i got the error

SQL> startup
ORACLE instance started.