Re: MySQL Question

["Aaron D. Turner" <aturner@best.com>]

-----BEGIN PGP SIGNED MESSAGE-----


On Sat, 26 Dec 1998, Dana M. Diederich wrote:

> > 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.

So does that mean approx. once every 100 entries submitted we corrupt our
database?  I guess I don't understand what "atomic" means.

- -- 
Aaron Turner           | Either which way, one half dozen or another. 
aturner@pobox.com      | Check out the Red Hat Linux User's FAQ Online!
www.pobox.com/~aturner | http://www.pobox.com/~aturner/RedHat-FAQ/
All emails from this account are PGP signed.  Lack of a signature is "bad".
PGP Key fingerprint = FB E1 CE ED 57 E4 AB 80  59 6E 60 BF 45 1B 20 E8



-----BEGIN PGP SIGNATURE-----
Version: 2.6.2

iQCVAwUBNoWCaTM3jpXy1kJtAQFXtwP8CQpsvyb9NunbkyW0K6HkFQxibhGBh8pv
d5aGJw4VPInZBx6cQNLAnKeMpgYtGmzDhT0PpuhnQP8VHnUGGK1NUOm98u/SgmFl
U3GuXzyMzwiD3KepL/hzOdX8IIpPecJRKLAxj9DHyHs4PCesFLsio6iNLMYtHce7
JZ6JvjWMpdI=
=mEE+
-----END PGP SIGNATURE-----