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

SUGGESTION: LOAD DATA INFILE with Multiple CSV simultaneous import

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Server
    • Labels:

      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

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

              Dates

              Created:
              Updated: