importing dbf files into mysql

Replies

• 

  slashfear

  Hi Rohit,
  
  You can use Load data as shown below,
  
  
  

  LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE '[I]file_name[/I]'
      [REPLACE | IGNORE]
      INTO TABLE [I]tbl_name[/I]
      [CHARACTER SET [I]charset_name[/I]]
      [{FIELDS | COLUMNS}
          [TERMINATED BY '[I]string[/I]']
          [[OPTIONALLY] ENCLOSED BY '[I]char[/I]']
          [ESCAPED BY '[I]char[/I]']
      ]
      [LINES
          [STARTING BY '[I]string[/I]']
          [TERMINATED BY '[I]string[/I]']
      ]
      [IGNORE [I]number[/I] LINES]
      [([I]col_name_or_user_var[/I],...)]
      [SET [I]col_name[/I] = [I]expr[/I],...]
  

  For further help or reference you can visit the following link ( which can give you the clear picture of how to do that process) :
  
  #-Link-Snipped-#
  
  Hope the information was useful for you!!!!😁