I am trying to import a txt file like this:
into a table. I use this command-- load data local infile "../chemtypes2.txt" into table chemistry(chemtype);
however, it only reads the top line into the chemtype column of the table--any ideas as to why? thanks for any help.