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!)

About this user

« Newer Snippets
Older Snippets »
2 total  XML / RSS feed 

Apache rewrite rules

Pass all requests for non-existing files or directories to index.php
RewriteCond        %{REQUEST_FILENAME}        !-f                
RewriteCond        %{REQUEST_FILENAME}        !-d
RewriteRule        ^(.*)$                    index.php        [L]

Change many tables at once

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>
« Newer Snippets
Older Snippets »
2 total  XML / RSS feed