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?

Did you know?Explore Trending and Topic pages for more stories like this.
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

mysq_num_rows
Hi,

I want to use:

Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is

A href problem under php
Hello...

I tried to explain the issue in an earlier post.. but was not clear enough....

disable all input buttons
Hello Friends,

suppose i do have a file ( file.php ) has a submit button

Code: [Sele

max function question
Hi All
Ihave a table that holds shipment numbers and dates like this

select * from

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

pull content
I have an existing page, domain/adverts.php which has a good PR. I've just rebuilt my site and the n

How to show more than 1 users with this code...
Hello,
i have a table that shows users only if I, as Administrator, want to be shown. But its sho

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