Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Change many tables at once (See related posts)

I had to ALTER TABLE a lot of tables. This code runs a certain ALTER TABLE statement on each table in a database

echo 'SHOW TABLES' |mysql -N -u <user> <db> | sed -e "s/^\(.*\)$/ALTER TABLE \`\1\` ADD (created TIMESTAMP DEFAULT '2007-12-01', modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);/g" | mysql -u <user> <db>
to mysql shell by rutgerw on Tue Nov 13 14:05:01 +0000 2007

You need to create an account or log in to post comments to this site.


Related Posts