Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Import Multiple Csv Files?

forums › forums › SQLyog › Using SQLyog › Import Multiple Csv Files?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • August 11, 2009 at 4:36 pm #11626
      gutterboy
      Member

      Is this possible?

      Thanks!

    • August 11, 2009 at 5:57 pm #29448
      peterlaursen
      Participant

      Yes it is.

      To do this you will need to use the ODBC-based import option (available only in ENTERPRISE). It you have multiple ext/csv files in the same folder the text-ODBC driver will identify each file as a 'table' on the. You may next select to import into the same table on .

      With CSV-import based on MySQL “LOAD DATA” syntax it is not possible to import more than one file in one operation.

      [attachment=1234:csvasodbc.jpg]

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.