----- Original Message -----
From: "Craig Meyers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 3:20
Subject: SELECT query
> List,
>
> Our site is running mysql server version 3.22.32
> I'm a power user - not the DBA, so forgive my ignorance.
>
> Is it possible to corrupt data with a SELECT query?
Very unlikely. Have a look at the logs and see if something else was being
performed at around the same time.
>
> The connection is made via a shell script:
>
> mysql -h servername -u userid -ppassword database <<QUERY_INPUT
> SELECT c.id, s.id
> FROM customers c, simulations s
> WHERE c.name = 'Customer Name Here'
> AND s.cust_id = c.id
> AND s.name = 'Simulation Name Here'
> QUERY_INPUT
>
> During the period I was testing this script, our DBA indicated we lost
some
> data.
> Is this just a coincidence? I can't see how a benign query could cause
such
> a problem.
>
>
> Thanks.
> Craig Meyers
> Senior Engineer
> Invensys Dynamic Simulation
>
>
>
----------------------------------------------------------------------------
----
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
