Updated: 05/15/2008

Simple csv to MySQL tool

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There''s a download button for pulling in the csv file. A CREATE button will create a simple database using VARCHAR() with all the fields length set to the longest length of any field. The INSERT button will insert the data. The BUILD FIELD LIST button does just that so you can select the field if you''re doing an UPDATE operation. Index fields in the database are shown. There are few checks to ensure that an operation will succeed. INSERT into a table that doesn''t exist for example will error etc. The code is heavily commented and should be ewasy to follow/amend.

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Tags
  • code error sql,
  • code example sql,
  • code sql,
  • contains in sql,
  • contains sql,
  • contains sql query,
  • create database in mysql,
  • create database in sql,
  • create database mysql,
  • create database sql query,
  • create in mysql table,
  • create in sql table,
  • create index mysql,
  • create index sql,
  • create index sql example,
  • create mysql database,
  • create mysql table,
  • create sql database,
  • create table in mysql,
  • create table in sql,
  • create table mysql,
  • create table sql,
  • create table sql example,
  • create table sql query,
  • csv database,
  • csv download,
  • csv in mysql,
  • csv mysql,
  • csv to mysql,
  • csv to mysql table,
  • csv to sql,
  • data into mysql table,
  • database download mysql,
  • database example mysql,
  • database example sql,
  • database names sql,
  • database sql index,
  • download mysql database,
  • download mysql query,
  • download sql,
  • download sql database,
  • example for sql,
  • example of sql code,
  • example query sql,
  • example sql code,
  • example sql database,
  • example sql insert,
  • example sql query,
  • example sql update,
  • exist in mysql,
  • exist in sql,
  • exist sql,
  • file csv,
  • for update of sql,
  • for update sql,
  • if in mysql query using,
  • if sql,
  • in mysql query,
  • in query sql,
  • in select sql,
  • in sql query,
  • in sql update,
  • index in sql,
  • index in sql database,
  • index mysql,
  • index mysql create table,
  • index mysql database,
  • index mysql table,
  • index sql,
  • index sql table,
  • index table mysql,
  • index table sql,
  • insert data into mysql,
  • insert in sql,
  • insert into database sql,
  • insert into in sql,
  • insert into mysql,
  • insert into mysql table,
  • insert into select mysql,
  • insert into select sql,
  • insert into set sql,
  • insert into sql,
  • insert into sql example,
  • insert into sql query,
  • insert into sql select,
  • insert into sql table,
  • insert into table in sql,
  • insert into table mysql,
  • insert into table sql,
  • insert mysql,
  • insert mysql select,
  • insert query,
  • insert query sql,
  • insert select mysql,
  • insert select sql,
  • insert sql,
  • insert sql example,
  • insert sql query,
  • insert sql select,
  • insert with select sql,
  • into list select sql,
  • into select sql,
  • length in sql,
  • mysql create database,
  • mysql create index,
  • mysql create table,
  • mysql csv,
  • mysql csv download,
  • mysql database download,
  • mysql database example,
  • mysql database file,
  • mysql database file names,
  • mysql database names,
  • mysql database table,
  • mysql download,
  • mysql example,
  • mysql example database,
  • mysql if exist,
  • mysql index,
  • mysql index table,
  • mysql insert,
  • mysql insert example,
  • mysql insert into,
  • mysql insert into select,
  • mysql insert into set,
  • mysql insert into table,
  • mysql insert query,
  • mysql insert select,
  • mysql into file,
  • mysql into table,
  • mysql list database,
  • mysql query,
  • mysql query and,
  • mysql query and or,
  • mysql query error,
  • mysql query example,
  • mysql query update,
  • mysql query with,
  • mysql select,
  • mysql select database,
  • mysql select into,
  • mysql select into file,
  • mysql select into table,
  • mysql select query,
  • mysql set update,
  • mysql simple query,
  • mysql sql select,
  • mysql table data,
  • mysql to csv,
  • mysql to csv download,
  • mysql update example,
  • mysql update query,
  • mysql update select,
  • mysql update set,
  • mysql update set select,
  • mysql update table,
  • mysql update table set,
  • mysql using index,
  • operation in sql,
  • query mysql database,
  • query select mysql,
  • query select sql,
  • query sql,
  • query sql database,
  • query sql table,
  • query sql update,
  • select all sql,
  • select for update mysql,
  • select for update sql,
  • select into mysql,
  • select into sql,
  • select into sql query,
  • select into table mysql,
  • select query,
  • select query in sql,
  • select query mysql,
  • select select sql,
  • select sql,
  • select sql query,
  • select sql update,
  • select table names mysql,
  • select table names sql,
  • set sql update,
  • simple download,
  • simple mysql database,
  • sql and insert,
  • sql and insert into,
  • sql code,
  • sql contains,
  • sql contains query,
  • sql create,
  • sql create database table,
  • sql create index,
  • sql create index example,
  • sql create table,
  • sql create table example,
  • sql database file,
  • sql does,
  • sql does table exist,
  • sql error,
  • sql error code,
  • sql error code list,
  • sql example,
  • sql example insert,
  • sql example query,
  • sql example update,
  • sql exist,
  • sql exist in,
  • sql if,
  • sql if exist,
  • sql if exist table,
  • sql index,
  • sql index of,
  • sql insert,
  • sql insert data,
  • sql insert example,
  • sql insert if,
  • sql insert into,
  • sql insert into select,
  • sql insert into table,
  • sql insert query,
  • sql insert query example,
  • sql insert select,
  • sql insert select example,
  • sql insert table,
  • sql insert update,
  • sql insert using,
  • sql insert using select,
  • sql insert with,
  • sql insert with select,
  • sql length,
  • sql length of field,
  • sql list table names,
  • sql query,
  • sql query and,
  • sql query and or,
  • sql query contains,
  • sql query data,
  • sql query database,
  • sql query example,
  • sql query if,
  • sql query in,
  • sql query insert into,
  • sql query list,
  • sql query mysql,
  • sql query select,
  • sql query select into,
  • sql query table,
  • sql query table list,
  • sql query table names,
  • sql select,
  • sql select contains,
  • sql select database,
  • sql select in,
  • sql select in select,
  • sql select index,
  • sql select insert,
  • sql select insert into,
  • sql select insert update,
  • sql select into,
  • sql select into example,
  • sql select into file,
  • sql select into table,
  • sql select query,
  • sql select query example,
  • sql table,
  • sql table update,
  • sql update,
  • sql update example,
  • sql update query,
  • sql update query example,
  • sql update select,
  • sql update select query,
  • sql update set,
  • sql update set example,
  • sql update set select,
  • sql update table,
  • sql update table set,
  • sql using,
  • sql using in,
  • sql using index,
  • sql_query,
  • table exist sql,
  • table names in mysql,
  • table names in sql,
  • table simple,
  • update in sql,
  • update mysql,
  • update mysql query,
  • update mysql table,
  • update query in mysql,
  • update query in sql,
  • update query mysql,
  • update query sql,
  • update query sql example,
  • update set mysql,
  • update set select sql,
  • update set sql,
  • update sql,
  • update sql example,
  • update sql query,
  • update sql query example,
  • update table in mysql,
  • update table in sql,
  • update table mysql,
  • update table set mysql,
  • update table set sql,
  • update table sql,
  • update table sql query,
  • using mysql database,
  • using sql,
  • using update in sql,
  • with index sql
  • ...
• Platforms
  • Linux,
  • Windows
• Licenses
  • Freeware
• Author
  • Phillip Biggs