スプレッドシートでCSV吐き出して小さなDBのテストデータを作ると結構楽だった ref: http://qiita.com/ikuwow/items/a783a83924f88c48a1b5

file0.txt

create table if not exists users (
    id serial not null primary key,
    email varchar(255) not null,
    name varchar(255) not null,
    password varchar(255) not null,
    created datetime not null default now()
) engine=innodb;

file2.txt

$ mysql -u root application --local-infile=1
mysql > load data local infile './users.csv' into table users fields terminated by ','

file3.txt

#!/bin/bash

mysql -u root --execute="drop database application"
mysql -u root --execute="source schema.sql"


mysql -u root --local-infile=1 application --execute="\
    load data local infile './users.csv' into table users fields terminated by ','
"

users.csv