Wil
Reputation: 10604
How do I import a CSV to MySQL where there is a space in a column name?
I have been handed a very large CSV file that needs to be imported to a database.
I have done this before and know the general syntax, however, I am failing and getting errors on the column names as they contain a space.
I have tried different sorts of quotes without luck and have been searching the internet for the past hour.
Can anyone help me?
Upvotes: 0
Views: 347
Answers (1)
Related Questions
- How to avoid white spaces being created while importing data from CSV file to MySQL table
- MySQL: Importing csv into table with quotation marks
- php with mysql: import .csv delimited space
- Mysql import data contain commas with quotes
- Keep special characters when importing into mysql from csv
- Importing CSV into MySQL leaving quote at end of line
- Loading a CSV file with inconsistent spaces after commas
- How to load data into a MySQL table without spaces?
- How to escape commas inside CSV values when importing table to MySQL?
- MySQL import from csv file with character exceptions