Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12446

SUGGESTION: LOAD DATA INFILE with Multiple CSV simultaneous import

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Server

    Description

      Hi!

      I would like to suggest that LOAD DATA INFILE support a MULTIPLE=YES|NO clause, which allows multiple CSV import.

      For example, If we have 100 CSV called myfile01.csv, myfile02.csv, [...], myfile03.csv, by adding previous clause within load data infile syntax we would be able to import all those CSV which have the same data structure simultaneously.

      In fact, that would be a major advantage in comparison with other RDBMS, as it would be the only one supporting such behavior.

      At this moment, this behavior can also be achieved by using Connectors, but the point is to do it all in MariaDB itself.

      Thank you!
      Juan

      Attachments

        Activity

          People

            Unassigned Unassigned
            Juan Juan Telleria
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.