Jump to content

Do I need to LOCK tables?


dptr1988

Recommended Posts

I'm working on a script that reads numbers out of a row in the table, adds/subtracts the numbers, then updates the row in the table. I was wondering if another script reads the same row before the first script updates that row and then updates that row before or after the first after the first script updats the row, if the row would be incorrect. I don't think that is easy to understand so let me try again with a scenario with exagerated timing.

Script 1 and Script 2 take all of the columns in row1 and add 1 to each column then update row1 with the new columns

Here is the table for the example:

[tt]    num1 num2 num3
-------------------
row1 1    1    1


This is the sequence of scenario:

Seconds    Action
------------------------------------------------
00            Script 1 reads all of the columns in row 1
01            Script 2 reads all of the columns in row 1
02            Script 1 is done processing and updates row1 with these values 2,2,2
03            Script 2 is done processing and updates row1 with these values 2,2,2
[/tt]

Is it possible for this scenario to happen? If it does happen, Would the value of row1 be 2,2,2 instead of 3,3,3 like I was wanting?

I haven't had trouble like this yet, but was worried that I might cause trouble.

Thanks



Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.