LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?

by

This loads and converts in one step, no need for another table. For more information see the manual.

LOAD DATA INFILE 'file.txt'
INTO TABLE t1
FIELDS TERMINATED BY ',' 
(column1, @var1, column3, ...)
SET column2 = STR_TO_DATE(@var1,'%Y%m%d')

More Related Contents:

  1. Delimiters in MySQL
  2. How to store Emoji Character in MySQL Database
  3. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  4. MySQL: Quick breakdown of the types of joins [duplicate]
  5. Any way to select without causing locking in MySQL?
  6. Log all queries in mysql
  7. Truncate all tables in a MySQL database in one command?
  8. Cast from VARCHAR to INT – MySQL
  9. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  10. Find distance between two points using latitude and longitude in mysql
  11. How to convert result table to JSON array in MySQL
  12. Export and Import all MySQL databases at one time
  13. MySQL: Select top n max values?
  14. MySQL search in comma list [duplicate]
  15. What is MySQL’s default ON DELETE behavior?
  16. MySQL error 1022 when creating table
  17. How do I setup ASP.NET MVC 2 with MySQL?
  18. mysql DECLARE WHILE outside stored procedure how?
  19. SELECT query return 1 row from each group
  20. MySql Single Table, Select last 7 days and include empty rows
  21. How can I check MySQL engine type for a specific table?
  22. mysql SQL: specific item to be first and then to sort the rest of the items
  23. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  24. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  25. Where does MySQL store database files on Windows and what are the names of the files?
  26. When is a timestamp (auto) updated?
  27. Should I normalize my DB or not?
  28. Why is connecting to MySQL server so slow?
  29. Connect to mysql server without sudo
  30. How to search and replace all instances of a string within a database?

Leave a Comment