Create mysql table directly from CSV file using the CSV Storage engine?

I just discovered csvkit, which is a set of Unix command-line tools for CSV files. I installed it on my Mac with pip install csvkit. The command was:

csvsql --dialect mysql --snifflimit 100000 bigdatafile.csv > maketable.sql

You can alternatively provide a DB connection string and it can load the table directly.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Case statement in MySQL
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. how to drop partition without dropping data in MySQL?
  6. MySQL equivalent of DECODE function in Oracle
  7. importing a CSV into phpmyadmin
  8. How to map data on CSV to web pages?
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  11. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  12. What is an MDF file? [closed]
  13. ORA-00904: invalid identifier
  14. Unknown column in ‘field list’ error on MySQL Update query
  15. Unknown column in ‘field list’ error on MySQL Update query
  16. Self Join to get employee manager name
  17. MySQL – Operand should contain 1 column(s)
  18. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  19. MySQL create table if not exists and insert record only if table was created
  20. Rename a table in MySQL
  21. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  22. How should I tackle –secure-file-priv in MySQL?
  23. How do I use MySQL through XAMPP?
  24. How do I use properly CASE..WHEN in MySQL
  25. Why do we need “Relationships” between tables at all?
  26. How can I do a FULL OUTER JOIN in MySQL?
  27. MySQL query String contains
  28. What’s the difference between VARCHAR and CHAR?
  29. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  30. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  31. How to declare a variable in MySQL?
  32. Can’t find mysqladmin on Mac OSX 10.6.8
  33. Export Pervasive to MySQL (C#)
  34. MySQL Cannot Add Foreign Key Constraint
  35. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  36. How do I restore a dump file from mysqldump?
  37. Invalid column count in CSV input on line 1 Error
  38. How to split the name string in mysql?
  39. How do I quickly rename a MySQL database (change schema name)?
  40. Invalid column count in CSV input on line 1 Error
  41. How do I import an SQL file using the command line in MySQL?
  42. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  43. mysql Foreign key constraint is incorrectly formed error
  44. MySQL: Invalid use of group function
  45. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  46. How can I return pivot table output in MySQL?
  47. Compare dates in MySQL
  48. MySQL SELECT increment counter
  49. MySQL “WITH” clause
  50. What is the difference between JOIN and UNION?
  51. Create a new database with MySQL Workbench
  52. MySQL Multiple Joins in one query?
  53. MySQL syntax for Join Update
  54. How to get size of mysql database?
  55. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  56. 1052: Column ‘id’ in field list is ambiguous
  57. 1052: Column ‘id’ in field list is ambiguous
  58. difference between primary key and unique key
  59. MySQL combine two columns into one column
  60. Simple way to calculate median with MySQL
  61. Creating a search form in PHP to search a database?
  62. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  63. Error 1046 No database Selected, how to resolve?
  64. What is it exactly a BLOB in a DBMS context
  65. MySQL Error 1264: out of range value for column
  66. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  67. How to store arrays in MySQL?
  68. How to concatenate text from multiple rows into a single text string in SQL Server
  69. What is semi-join in database?
  70. Remove duplicate rows in MySQL
  71. How to SUM and SUBTRACT using SQL?
  72. phpMyAdmin – Error > Incorrect format parameter?
  73. The backend version is not supported to design database diagrams or tables
  74. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  75. Cast from VARCHAR to INT – MySQL
  76. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  77. How do you force mysql LIKE to be case sensitive?
  78. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  79. MySQL – UPDATE multiple rows with different values in one query
  80. Postgres Error: More than one row returned by a subquery used as an expression
  81. How to create a MySQL hierarchical recursive query?
  82. ERROR 1148: The used command is not allowed with this MySQL version
  83. Bulk load data conversion error (truncation)
  84. Insert into a MySQL table or update if exists
  85. How to round down to nearest integer in MySQL?
  86. How do I reset a sequence in Oracle?
  87. MySQL starts with searching issue
  88. Query to convert from datetime to date mysql
  89. Is it possible to GROUP BY multiple columns using MySQL?
  90. MySQL error: key specification without a key length
  91. How can I output MySQL query results in CSV format?
  92. Best way to test if a row exists in a MySQL table
  93. Check if MySQL table exists without using “select from” syntax?
  94. mysql update column with value from another table
  95. The used SELECT statements have a different number of columns
  96. How to create a foreign key in phpmyadmin
  97. what is the difference between triggers, assertions and checks (in database)
  98. How to delete from multiple tables in MySQL?
  99. MySQL: Can’t create table (errno: 150)
  100. How to copy a row and insert in same table with a autoincrement field in MySQL?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)