> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Ken Kixmoeller (ProFox) > Sent: Monday, April 18, 2011 2:32 PM > To: [email protected] > Subject: [NF] [MySQL] Weird, weird WEIRD behavior > > OK, anyone out there have a WAG about this? > > In a system I have that uses MySQL as the data store, I need to update > 2 fields to fix a data error that resulted from a bug that some idiot > programmer introduced. (This particular idiot shall go unnamed, but he > is the sole author of this particular application.) > > Here is the situation: > > -- two fields were left blank > -- there are 2 *other* fields which are redundant 99% of the time (and > in 100% of these cases). > -- I ran a simple query: > > Update the_table set field_A = field_B, field_C = field_D where > field_a = 0 > > -- The intended result was fine, but there was an unintended > additional result: field_F was set to 14 in all of the affected > records. > > There are no stored procedures in the database at all, much less > pertaining to this table and field. > > I'm stumped. > > Ken > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/profox > OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: > http://leafe.com/archives/byMID/profox/BANLkTikdKU0mywWouxRn4eWV6RHkT8Oc YQ > @mail.gmail.com > ** All postings, unless explicitly stated otherwise, are the opinions of > the author, and do not constitute legal or medical advice. This statement > is added to the messages for those lawyers who are too stupid to see the > obvious. > > Report [OT] Abuse: > http://leafe.com/reportAbuse/[email protected] ai > l.com
Is it set to 14, or just appearing as 14... IOW - is it some ASCII thing i.e. what is CHR(14) ? Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/69f310c05dd83c48a84ba3769ce1ecf80489d...@tntriexevs02.triadhospitals.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
