Tech Thought

Tech tips, hints, and general musings. PHP, Perl, Mysql, Javascript, AJAX, JSON, Linux, Mac OSX

Entries Tagged ‘csv’

CSV to SQL Converter - Now supports UPDATE statements

I’ve modified my CSV to SQL conversion tool (csv2sql.com) so that it now can produce both INSERT and UPDATE SQL statements from your CSV file.  Previously the tool only created INSERT statements, so you could easily insert all your CSV data into your database table.  
However this is rather limited - what if you want to later [...]

Leave a Comment

How-To: Insert CSV file into Database Table (csv2sql.com)

I’ve developed a simple online tool that allows you to convert a CSV file into SQL statements that can be inserted into a database table.  It’s a simple process:

Create a CSV file containing your data
The first row of the CSV file should contain column titles which exactly match the fields in your database table
Go to [...]

Leave a Comment