![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
anotheritcrisis.livejournal.com posting in ![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
techrecoveryNot really a tech support issue per se, except on my own end...
Warning: Do not use the following command to TRY and update only one row:
"Update myTable SET field1 = newValue, field2 = newValue"
I now have a huge table with each record the same. Forgetting to set the WHERE ID = IDNumber clause is BAD.
Thank god for backups.
Warning: Do not use the following command to TRY and update only one row:
"Update myTable SET field1 = newValue, field2 = newValue"
I now have a huge table with each record the same. Forgetting to set the WHERE ID = IDNumber clause is BAD.
Thank god for backups.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
no subject
Date: 2004-11-04 11:57 am (UTC)"honest boss, it was a typo!"
Luckily...
Date: 2004-11-04 12:38 pm (UTC)