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

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

foreach and array need help combining
Hi guys.

Here's the code

Code: array(
'tag' => 'code',<

Linux socket programming
Where can I find a good introduction to socket programming?

why isn't this PHP code working ???
it's suppose to find a name on the database.

<?php

$s = $_POST["lname&

Undefined variables
hi
----------------------------------------------------------------------------------------------

LOOPing Problem
Hello All!

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

Multiple upload and Resize
I would like some help on my script I have the for my index.php

////

<html&

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire

Passing Arguments to execlp()
I'm writing a program that mimics a unix shell. It's supposed to take commands with arguments and ex

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put