A very simple PHP script that converts a CSV file to a SQL dump. The script expects the CSV file to be in a proper format that is readable to PHP's fgetcsv
.
All values should be enclosed in double quotes (") and seperated by commas (,). Furtheremore, the first line of your file is used for the names of the rows.
Here's a simple example of a proper CSV file:
"id", "book", "author"
"1", "1984", "George Orwell"
"2", "Hamlet", "Shakespeare"
-
Make this command executable
chmod +x ./csv2sql
-
Use it from the commandline like this
csv2sql file.csv table_name
The output will go to stdout, so to write it to a file do something like this:
csv2sql file.csv table_name > import.sql
Written by Hay Kranen (@hayify).
Patches and comments welcome on Github