Import csv to mysql phpmyadmin questions

[dethfire]

I have a csv file that is formatted as such:

1,1,Abdominal Abscess
1,2,Abortion Septic
1,3,Abscess
1,4,Acinetobacter Infections
1,5,AIDS-Related Opportunistic Infections
1,6,Anaplasmosis
1,7,Anthrax
1,8,Arthritis Infectious
1,9,Arthritis Reactive
1,10,Aspergillosis

...

In phpmyadmin I have the following options:

Replace table data with file
Ignore duplicate rows
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Column names

and I’m really not sure what to put in for these? anyone know?

[guelphdad]

Replace table data with file
Ignore duplicate rows
Fields terminated by – you’d want a comma since you have one after each field
Fields enclosed by – use a " here just in case you have ’ in your data like O’Toole
Fields escaped by
Lines terminated by – usually \r\f if you are doing it manually, not sure in phpmyadmin
Column names – these are used only if you are importing data into specific rather than all columns

[ronipthoms]

@guelphdad

Replace table data with file
Ignore duplicate rows
Fields terminated by – you’d want a comma since you have one after each field
Fields enclosed by – use a " here just in case you have ’ in your data like O’Toole
Fields escaped by
Lines terminated by – usually \r\f if you are doing it manually, not sure in phpmyadmin
Column names – these are used only if you are importing data into specific rather than all columns

Hope this tool may help you
http://www.ronithomas.com/csv-to-mysql-converter/