Can mysql import a csv or other txt file into one column?
In mysql we can import data files -
load data infile 'file.txt'
into table `text`
fields terminated ' '
lines terminated '\n'
My question is can we import a file with unknown columns all into one
column? Or possibly can we create columns that we need on the fly?
No comments:
Post a Comment