| Xgc | Rappermas: rollback; -- if the transaction was not committed. |
| Rappermas | Xgc: how do i know if a transaction was committed? |
| ToeBee | assuming your storage engine even supports transactions :) |
| Rappermas | InnoDB |
| Xgc | Rappermas: If it was committed you don't have an option, beyond some type of backup recovery. |
| Rappermas | dammit, i have to redo so much by hand now this sux...one wrong semicolon and you're fucked |
| action | Rappermas is going to use GUI tools from now on |
| Rappermas | is going to use GUI tools from now on |
| ToeBee | well did you try rollback? |
| Rappermas | ToeBee: Query OK, 0 rows affected (0.00 sec) |
| ToeBee | ah |
| Rappermas | ok, then, is there any way where i can update ranges of records at a time for example update product set size='foo' where id=701-800; |
| ToeBee | sure |
| Rappermas | how do i specify ranges of id's is it just like that |
| ToeBee | where id >= 701 and id <= 800 or BETWEEN |
| Rappermas | ah so like update product set size='foo' where id is BETWEEN 700 and 800? |
| ToeBee | drop the "is". and between is inclusive |
| Rappermas | ok |
| ToeBee | so that is like saying greater than or equal to 700 and less than or equal to 800 |
| Rappermas | right, thanks |
| ToeBee | and may I suggest testing things on a test database in the future :) |
| Xgc | Rappermas: rollback; always shows 0 rows affected. |
| Rappermas | ToeBee: lol, i knew exactly what i was doing but my finger slipped i was going to do a update product set size='2 x 3' where type='reg' but i hit the semicolon and enter key before i got to the where |
| Xgc | Rappermas: Never make updates to a production database by hand. Always toss final / tested SQL in a file and source that file. |
| Rappermas | so a couple of thousand records are now all the same Xgc: it's not product yet :) s/product/production it's a development database |
| Xgc | Rappermas: Any data you care about. |
| Rappermas | Xgc: yes, that i agree with |
| Xgc | [23:01] <Rappermas> dammit, i have to redo so much by hand now [23:01] <Rappermas> this sux...one wrong semicolon and you're fucked |
| ToeBee | hehe. done that before. Luckily this was on oracle and I could rollback :) |