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

I face problems to extract data from one table and insert it in another one
Hi,

For modifications, I have to extract data from one table and insert it in another one

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

PHP Multiples of 2, Show posts...not working (wordpress)
I have been using this code to show div.example with 6 li columns inside it, each li is a post with

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

no idea what to do...
I'm fed up. I had issues with code that I have working on a different site that didn't work on my cu

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

radio button reamains checked
Hello i'm trying to keep the state off my radio buttons so it shows which ones where clicked after t

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