I am trying to import a csv into a temp table in a MySQL DB. I am able to successfully import to the proper location via this command:
load data local infile '/home/user/accounts_test.
into table accounts_temp2
fields terminated by ','
lines terminated by '\n' (field1, field2, field3);
The data is getting into the table, however the name column in my csv data looks like Doe, John. So when I am importing it puts the last name in the name column and the first name into the next column. I have tried using Doe, John and that had the same effect as without the
Question: How do I get Doe, John to import into the same name column?
Also, when the date_entered and the date_modified gets imported it only shows 0000-00-00 00:00:00 as the results. See the screen shot attached for column.