A script written in PHP which converts CSV files to SQL files ready to be imported into a MySQL database.
PHP
Switch branches/tags
Nothing to show
Latest commit f12ff7d Feb 29, 2012 Joseph Hagerty Joseph Hagerty Strip the pathname during tablename creation
Permalink
Failed to load latest commit information.
README updated README Jan 18, 2012
php-csv2mysql.php Strip the pathname during tablename creation Feb 29, 2012

README

Chris Armstrong
chris@chrisarmstrong.me
   
Converts CSV files to .SQL files, with a CREATE TABLE and INSERT statements for each row of the CSV.
Will automatically ignore columns that contain no data, and will make all columns type VARCHAR with a size equal to the length of that column's longest value.
TO USE: php csv_to_sql.php inputfile.csv outputfile.sql database_name