LOAD
      
       DATA INFILE "d:
      
        /
      
      insert_data.csv"      
      
        --
      
      
        指定需要得去CSV文件的位置
      
      
        REPLACE
      
      
        INTO
      
      
        TABLE
      
       DEMO                    
      
        --
      
      
        指定要插入的表注意REPLACE為替換
      
      
        CHARACTER
      
      
        SET
      
       gb2312                       
      
        --
      
      
        指定編碼，以免亂碼
      
      

FIELDS TERMINATED 
      
        BY
      
       "," ENCLOSED 
      
        BY
      
       ""    
      
        --
      
      
        指定分隔符為,被""包圍
      
      

LINES TERMINATED 
      
        BY
      
       "\r\n";                
      
        --
      
      
        指定每行以什么結尾
      
      
        

      
    

      
        LOAD
      
       DATA INFILE 
      
        '
      
      
        /home/test/dump/ip_location.csv
      
      
        '
      
      
        INTO
      
      
        TABLE
      
      
         ip_location


      
      
        CHARACTER
      
      
        SET
      
      
         utf8

FIELDS TERMINATED 
      
      
        BY
      
      
        '
      
      
        ,
      
      
        '
      
       ENCLOSED 
      
        BY
      
      
        '
      
      
        "
      
      
        '
      
      ;