import csv to mysql phpmyadmin questions

Discussion in 'MySQL' started by dethfire, Oct 21, 2010.

0
  1. #1
    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

...
    Code (markup):

    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?
     
    dethfire, Oct 21, 2010 IP