Hi all,
I am trying to import a txt file like this:
AGM
Alkaline
Button/Coin
Calcium
Carbon Zinc

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.
regards,
Patty