Makes a throwaway table from a flat file with lists of field names (all nullable varchars)

scratchTable.sh

#!/usr/bin/env sh

echo "CREATE TABLE `basename ${1,,} ${1: -4}` ("
echo "    id INTEGER AUTO_INCREMENT,"
while read line
do
    no_space=${line/ /_}
    field_name=${no_space,,}
    echo -e "    $field_name VARCHAR(50) default NULL,"
done < $1
echo "    PRIMARY KEY(id)"
echo ") TYPE=innodb;"