|
|
Back to UserFriendly Strip Comments Index
|
Well, you people are right about MySQL... | by bwkaz | 2007-05-09 10:31:47 |
|
ouchie | by dennismv | 2007-05-09 10:37:23 |
| Eeeew, Office... :-P |
by bwkaz |
2007-05-09 10:47:29 |
(I don't run Windows. OO.o would probably work just as well, but I don't have that installed either, because I haven't needed it yet.)
I can hack a Python program together to pull all the records out of the database, figure out the required value for the Points field in each row (based on another WhoPlayedWhom table), and run an update easily enough. I just wish I didn't have to. :-)
(And I'm not comfortable changing lots of rows in the mysql client after this, either, so the "port them back to the database" part may not work either. At least with Python, I can just print out the update statement and the parameter values that it would use in each case, and double check them before running it "live".) |
|
[ Reply ] |
|
ya | by dennismv | 2007-05-09 11:02:23 |
|
Sounds like it could be done with SQL | by Arachnid | 2007-05-09 13:23:47 |
|
one liner ? | by dennismv | 2007-05-09 14:22:06 |
|
Sure. CASE WHEN blah THEN foo ELSE bar END (n/t) | by Arachnid | 2007-05-09 14:58:43 |
|
mm thanks ! learn something new every day :) (n/t) | by dennismv | 2007-05-09 15:27:05 |
|
Eh, you may be right, but it's done already. :-) | by bwkaz | 2007-05-09 16:07:27 |
|
|
[Todays Cartoon Discussion]
[News Index]
|
|
