Re: using perl to lock tables without locking myself

You do want to use your SQL server to do this - there is always the possibility that some other process not under your control will attempt to use your database. You don't mention what database server it is that you are using but does it support the:


    LOCK TABLE foo IN EXCLUSIVE MODE
[download]

syntax ?

/J\

Comment on Re: using perl to lock tables without locking myself Download Code

Replies are listed 'Best First'.
Re: Re: using perl to lock tables without locking myself by sdyates (Scribe) on Mar 13, 2002 at 02:51 UTC
It is amazing. When you look at code over and over, quite often the most obvious mistake is missed. Seeing my question online alog with your answer forced me to look at it again. Lock tables support read will not work if one wants to write. I saw it as, lock the table read access to all but me... oh well... I still need to read over the exclusive mode... mysql.com is nto the best... I think I need a mysql for dummies book. Anyhows thanks for the help. I know some of you think I am pushing it by aasking a mysql question, but hey, I did not know whether the problem was with how I was phrasing the mysql code in perl, or with my mysql sql statements... Remember, there is no such thing as a dumb question, just dumn users--sorry.	[reply]

Replies are listed 'Best First'.

Re: Re: using perl to lock tables without locking myself
by sdyates (Scribe) on Mar 13, 2002 at 02:51 UTC

Lock tables support read will not work if one wants to write. I saw it as, lock the table read access to all but me... oh well... I still need to read over the exclusive mode... mysql.com is nto the best... I think I need a mysql for dummies book. Anyhows thanks for the help.

I know some of you think I am pushing it by aasking a mysql question, but hey, I did not know whether the problem was with how I was phrasing the mysql code in perl, or with my mysql sql statements... Remember, there is no such thing as a dumb question, just dumn users--sorry.

[reply]