Skip to content

Instantly share code, notes, and snippets.

@deep-spaced
deep-spaced / 301 Insert.sql
Last active December 23, 2015 10:38 — forked from stevemeisner/301 Insert.sql
Updated redirect creation method for Typewriter.
INSERT INTO `redirects` (`match`, `redirect_to`, `account_id`, `created_at`, `updated_at`)
VALUES
('/old_page.php', '/new/page', 40, NOW(), NOW()),
('/old_page_two.php', '/new/page/two', 40, NOW(), NOW()),
('/old_page_three.php', '/new/page-two', 40, NOW(), NOW());
@deep-spaced
deep-spaced / Shell log.sh
Created May 2, 2012 13:39 — forked from jinto/Shell log.sh
Contortions needed to create an AWS RDS database using UTF-8
brew install rds-command-line-tools
rds-create-db-parameter-group mysql-utf8-55 --db-parameter-group-family mysql5.5 --description "MySQL 5.5 configured for UTF-8"
rds-modify-db-parameter-group mysql-utf8-55 \
--parameters="name=character_set_server, value=utf8, method=immediate" \
--parameters="name=character_set_client, value=utf8, method=immediate" \
--parameters="name=character_set_results,value=utf8,method=immediate" \
--parameters="name=collation_server, value=utf8_general_ci, method=immediate" \