Import CSV file directly into MySQL

by

but column names in csv and that in database table are different what should i do?

Not a problem. You can specify which CSV column gets imported into which database column.

LOAD DATA INFILE syntax

By default, when no column list is provided at the end of the LOAD DATA INFILE statement, input lines are expected to contain a field for each table column. If you want to load only some of a table’s columns, specify a column list:

LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);

What I like to do when I find the INFILE syntax too complicated is use a graphical client like HeidiSQL to click together the proper column order (it has a graphical preview) and copy+paste the generated SQL query.

More Related Contents:

  1. Importing CSV data using PHP/MySQL
  2. PHP code to convert a MySQL query to CSV [closed]
  3. Loading .sql files from within PHP
  4. Remove BOM () from imported .csv file
  5. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  6. Process very big csv file without timeout and memory error
  7. php+mysql Fatal error: Call to undefined function mysql_connect()
  8. drop down menu using php and mysql [closed]
  9. php code for multiple search box after connecting to mysql [closed]
  10. Checking the availability of rooms
  11. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  12. Using PHP 5.5’s password_hash and password_verify function
  13. Example of how to use bind_result vs get_result
  14. mysqli::query(): Couldn’t fetch mysqli
  15. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  16. Levenshtein: MySQL + PHP
  17. How to test if a MySQL query was successful in modifying database table data?
  18. jQuery UI Sortable, then write order into a database
  19. How do i “echo” a “Resource id #6” from a MySql response in PHP?
  20. convert php date to mysql format
  21. Special characters in PHP / MySQL
  22. IP address storing in MySQL database using PHP [duplicate]
  23. Password_Hash not working on my PHP login
  24. Select last 20 order by ascending – PHP/MySQL
  25. Formatting an SQL timestamp with PHP
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. Difference between mysql_fetch_array and mysql_fetch_row?
  28. mysql_fetch_array skipping first row
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment