That's my kind of ugly

Post #332,630 by drook 9/15/10 9:12:21 PM Reply	That's my kind of ugly I've done more maintenance that way than I care to remember. (And obviously more than I did remember at the time I was asking.) -- Drew
Post #332,632 by static 9/15/10 9:17:00 PM Reply	It's also an interesting lesson in pragmatism. Whilst it has it's own kind of elegance, a lot of purist programmers will cringe at this solution. They would prefer Leveraging The Power Of SQL directly, which ignores, however, the real-world issue that the database can't be unavailable for an hour whilst your big, clever query runs to completion... Wade. Q:Is it proper to eat cheeseburgers with your fingers? A:No, the fingers should be eaten separately.
Post #332,635 by drook 9/15/10 9:27:26 PM Reply	I've done round trips mySQL -> vim -> PHP -> mySQL Run a query and grab the output. Search/replace in vim. Save as a PHP script that issues updates in batches of n. I've done this to move sites to new servers when the respective mySQL boxes couldn't talk to each other. -- Drew

Welcome to IWETHEY!