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

Not showing whole name with mail () script
I sent up a simple mail form with the PHP mail() script. One problem is when it sends an email with

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H

Product categories for registration
Dear all,

We are going live with the Supplier registered next week. At standard, the 'sel

Easy administration on MySQL databases
My website is database driven and I am very tired of manually making queries to my tables in order t

Php script to read msword file
hi,

I need to read a msword file and i want to print the contents in that word file.

i

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

Parse error: syntax error, unexpected $end in
hello,
i receive the error :Parse error: syntax error, unexpected $end in C:xamppxampphtdocsh

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in