How to insert a space delimited text file into mysql using Python? [closed]

by

You need to set the delimiter to csv.reader function:

csvreader = csv.reader(textfile, delimiter="\t")

You didn’t do it in your code, so Python doesn’t split the line of your CSV file. That’s why it gives the error.

If you have the file with all the columns of MySQL table, you can use LOAD DATA INFILE
command. It’s much faster, then loading line by line.

LOAD DATA INFILE 'externaldatabase.txt'
INTO TABLE database_name.externaldatabase
FIELDS TERMINATED BY '\t';

More Related Contents:

  1. How do I parse a string to a float or int?
  2. How do I connect to a MySQL Database in Python?
  3. Installing specific package version with pip
  4. How to extract multiple JSON objects from one file?
  5. Why do integers in database row tuple have an ‘L’ suffix?
  6. sscanf in Python
  7. memory-efficient built-in SqlAlchemy iterator/generator?
  8. Install mysql-python (Windows)
  9. When to close cursors using MySQLdb
  10. Installing MySQL Python on Mac OS X
  11. How to read specific part of large file in Python
  12. How to build a flask application around an already existing database?
  13. Python 3.4.0 with MySQL database
  14. Python MySql Insert not working
  15. pandas read_html ValueError: No tables found
  16. What is the best solution for database connection pooling in python?
  17. Parsing a YAML file in Python, and accessing the data?
  18. Using MySQL in Flask
  19. trapping a MySql warning
  20. ImportError: No module named ‘MySQL’
  21. How to make an Inner Join in django?
  22. How does python and the regex module handle backslashes?
  23. Dynamic SQL Queries with Python and mySQL
  24. Simple Subquery with OuterRef
  25. Parsing a date that can be in several formats in python
  26. Print results in MySQL format with Python
  27. Split string at commas except when in bracket environment
  28. Why is ElementTree raising a ParseError?
  29. Python Parse CSV Correctly
  30. flask-login: can’t understand how it works

Leave a Comment