Re: inserting csv file contents in my sql

[hossein aspanani <hossein_aspanany@xxxxxxxxx>]

hi;
   
  you can use this sql statement;
   
  First ---> open your csv file in a text editor and find bellows:
  1) witch character or word is  field delimeter -----------------> $MyFieldDelim
  2) which character or word is row delimeter -----------------> $MyRowDelim
  3) Run This Script :
   
  LOAD DATA LOCAL
 INFILE '$FullCsvFilePath' 
 INTO TABLE $TargetTable
 FIELDS TERMINATED BY '$MyFieldDelim'
 LINES TERMINATED BY '$MyRowDelim'
   
   
  With Best Wishes 

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

[Non-text portions of this message have been removed]