How to import data from text file to mysql database

by

It should be as simple as…

LOAD DATA INFILE '/tmp/mydata.txt' INTO TABLE PerformanceReport;

By default LOAD DATA INFILE uses tab delimited, one row per line, so should take it in just fine.

More Related Contents:

  1. How do I import an SQL file using the command line in MySQL?
  2. Import data in MySQL from a CSV file using LOAD DATA INFILE
  3. How to import a CSV file into a MySQL table
  4. How to import XML file into MySQL database table using XML_LOAD(); function
  5. Migrate from Oracle to MySQL
  6. Import SQL file into mysql
  7. How can I correct MySQL Load Error
  8. How to Import Multiple csv files into a MySQL Database
  9. How can I import a database with MySQL from terminal?
  10. ERROR 1148: The used command is not allowed with this MySQL version
  11. Import CSV to Update only one column in table
  12. How I can Import data from CSV to MySQL?
  13. Import CSV to Update rows in table
  14. How to import a csv file into MySQL workbench?
  15. grant remote access of MySQL database from any IP address
  16. Should MySQL have its timezone set to UTC?
  17. JDBC batch insert performance
  18. SQL – Update multiple records in one query
  19. How to find gaps in sequential numbering in mysql?
  20. MySQL: Invalid use of group function
  21. auto increment primary leaving gaps in counting
  22. OUTPUT Clause in MySQL
  23. Relationship between catalog, schema, user, and database instance
  24. Sorting by date & time in descending order?
  25. passing LIMIT as parameters to MySQL sproc
  26. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  27. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  28. How to select data where a field has a min value in MySQL?
  29. MYSQL declaring variables
  30. MySQL Alter table causes Error: Invalid use of NULL value

Leave a Comment