Hooray Python

I love Python, because it lets me add 15 fields to a MySQL database in about 5 minutes, which is a lot less time than it would have taken to add them manually via the command-line client or PhpMyAdmin:

#!/usr/bin/python
#altertable.py

for i in range(1,6):
print "ALTER TABLE `items` ADD `img%d_title` VARCHAR(255);" % i;
print "ALTER TABLE `items` ADD `img%d_url` VARCHAR(255);" % i;
print "ALTER TABLE `items` ADD `img%d_caption` TEXT;" % i;

Save as `altertable.py` and run it from the shell:

`python altertable.py | mysql -u andy -pmyPassw0rd -h localhost mydatabase`

Not that it would have taken much longer to write in PHP, Perl, or even Java, but it's so *clean* in Python.

Syndicate content

Twitter

  • Found my misplaced Hero 329! It had been in the truck for a few weeks. #fountainpen — 5 years 31 weeks ago
  • Note to speakers & writers of the English language. It's D-R-A-W-E-R, not "draw". They speak english in what? — 5 years 31 weeks ago
  • How to compile + install xdebug for entropy.ch PHP5 on OS X Leopard: http://is.gd/4WkwW — 5 years 31 weeks ago
  • RT @ebertchicago: Martin Scorsese's list of the Top 11 Horror Films of All Time. http://j.mp/2AfcFX (yep, The Changling is on it) — 5 years 31 weeks ago
  • @krazykatmama it's OK, our neighbor saw my plight on Facebook and within 10 minutes came over and brought us cupcakes! — 5 years 31 weeks ago

Older

Contact

Andy Chase
(978) 297-6402
andychase [at] gmail.com
GPG/PGP Public Key