Re: MySQL Question

["Dana M. Diederich" <dana@realms.org>]

> After reading Rogers example of reading from a DB via DBI, I started
> thinking... How does one write to a MySQL DB.  At first, I thought it
> would be *easy*.  Then I rememebered something- locking.  Does MySQL
> support table or record locking?  Is there something the programmer needs
> to do to detect and do the appropriate work around or does DBI do that for
> us behind the sceens??  
> 
> perldoc DBI doesn't appear to have the answer.
> 
Howdy there.  Well, there is a locking function in mysql, but in practice, 
it's rarely required.  MySQL guarantees that any one SQL statement is atomic.
That's enough 99 percent of the time, especially for straightforward
applications.

Cheers.
-Dana
-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,
Dana M. Diederich        Phone: 1.501.855.7175
SMTP: dana@realms.org    HTTP:  http://realms.org/   ICQ: 16433785
Snail Mail: 19 Leicester Drive, Bella Vista, Ar 72714, USA
`Berkeley invented LSD and Unix, and I don't think that's a coincidence.'