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

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

header redirect problems? please help
Ok i am making a site that generates youtube thumbnails and i am generating an image that displays 1

Posting Serialized Data Not Working
I am trying to send an object from one PHP file to another using POST. I serialize the object and th

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - P

foreach and array need help combining
Hi guys.

Here's the code

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

downloading a file as HTML
Hi.
I'm rather confused with forcing a download. I just want to save dynamic content (from $_SESS