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.

In reply to Re: Re: using perl to lock tables without locking myself by sdyates
in thread using perl to lock tables without locking myself by sdyates

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.