Create MySQL Table from CSV File

csv-to-sql-table.bash

## prints create and insert SQL statements from a csv ##

#   csv-to-table [path] [name]
#   $ csv-to-table ./data.csv data_table

#   create table adapted from John Swapceinski,
#   http://dev.mysql.com/doc/refman/5.0/en/load-data.html#c12001

path=$(pwd)

echo "## create table ##"

echo "create table $2 ( "
head -1 $1 | sed -e 's/,/ varchar(255),/g'
echo " varchar(255) );"
echo

echo "## insert data ##"

echo "load data"
echo "local infile '$path/$1'"
echo "into table vars"
echo "fields terminated by ','"
echo "lines terminated by '\n';"
echo