MySql bulk load command line tool

by

mysqlimport.

takes the same connection parameters as the mysql command line shell. Make sure to use the -L flag to use a file on the local file system, otherwise it will (strangely) assume the file is on the server.

There is also an analogous variant to the load data infile command, i.e., load data local infile, according to which the file will be loaded from the client rather than the server, which may accomplish what you want to do.

More Related Contents:

  1. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  2. MySQL Insert query doesn’t work with WHERE clause
  3. Delete from two tables in one query
  4. How to speed up insertion performance in PostgreSQL
  5. Why would an IN condition be slower than “=” in sql?
  6. PostgreSQL GROUP BY different from MySQL?
  7. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  8. Fulltext Search with InnoDB
  9. MySQL dump by query
  10. MySQL’s now() +1 day
  11. Delete sql rows where IDs do not have a match from another table
  12. Rewriting mysql select to reduce time and writing tmp to disk
  13. How do I convert from BLOB to TEXT in MySQL?
  14. Can you access the auto increment value in MySQL within one statement?
  15. Which SQL query is better, MATCH AGAINST or LIKE?
  16. What does DELIMITER // do in a Trigger?
  17. MySQL equivalent of DECODE function in Oracle
  18. Mysql: how to select groups having certain values?
  19. How to create a multi-tenant database with shared table structures?
  20. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  21. MySQL #1140 – Mixing of GROUP columns
  22. MySQL: GROUP_CONCAT with LEFT JOIN
  23. Boolean vs tinyint(1) for boolean values in MySQL
  24. Find rows that have the same value on a column in MySQL
  25. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  26. How important are lookup tables?
  27. How to find all IDs of children recursively?
  28. ALTER TABLE without locking the table?
  29. MySQL: Typecasting NULL to 0
  30. How to get the byte size of resultset in an SQL query?

Leave a Comment