Python 3.4 code to load a csv file into MySql

by

You don’t need Python for that. You don’t even need a program for that. MySQL has a statement for reading CSV files.

See: https://dev.mysql.com/doc/refman/5.1/en/load-data.html , from the documentation:

LOAD DATA INFILE can be used to read files obtained from external sources. For
example, many programs can export data in comma-separated values (CSV) format,
such that lines have fields separated by commas and enclosed within double
quotation marks, with an initial line of column names. If the lines in such a
file are terminated by carriage return/newline pairs, the statement shown here
illustrates the field- and line-handling options you would use to load the file:

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES;

If the input values are not necessarily enclosed within quotation marks, use
OPTIONALLY before the ENCLOSED BY keywords.

Apart from that, MySQL also comes with a program called mysqlimport which can do that too.

More Related Contents:

  1. Python + Selenium: Wait until element is fully loaded
  2. Use a list of values to select rows from a Pandas dataframe
  3. Total memory used by Python process?
  4. Quoting backslashes in Python string literals [duplicate]
  5. How to get text with Selenium WebDriver in Python
  6. Compare two columns using pandas
  7. From ND to 1D arrays
  8. reducing number of plot ticks
  9. How to make file creation an atomic operation?
  10. What’s the easiest way to escape HTML in Python?
  11. Return string with first match for a regex, handling case where there is no match
  12. Reason for “all” and “any” result on empty lists
  13. Is the += operator thread-safe in Python?
  14. Sorting a set of values
  15. np arrays being immutable – “assignment destination is read-only”
  16. How to parse mjpeg http stream from ip camera?
  17. Maximum and minimum value of C types integers from Python
  18. Pandas Passing Variable Names into Column Name
  19. how to center image inside a rect pygame
  20. Printing a string prints ‘u’ before the string in Python?
  21. Is i = i + n truly the same as i += n? [duplicate]
  22. Number of digits in exponent
  23. How to convert Python’s .isoformat() string back into datetime object [duplicate]
  24. How to remove a field from the parent Form in a subclass?
  25. Is it possible to pass arguments into event bindings?
  26. Python super and setting parent class property
  27. Why does setattr fail on a bound method
  28. How is the Keras Conv1D input specified? I seem to be lacking a dimension
  29. multiprocessing: How can I ʀᴇʟɪᴀʙʟʏ redirect stdout from a child process?
  30. printing stdout in realtime from a subprocess that requires stdin

Leave a Comment