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

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010

Problem with array max size.
Hi to everyone,
I've got a homework about filling a bidimensional array un spiral shape, I alre

Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and place
I would like to have

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

db entry based on primary key
My "topics" table contains 10 entires
*--------------*
topicid topic
------

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

Port scanner problem
Hai
recently i developed one app through which u can check the opened and closed ports under an

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