Power BI Connector for CockroachDB

Build 22.0.8397

COPY Bulk Data Transfer

copybulkdatatransfer コマンドは、ファイルから大量のデータをロードしてテーブルに入力します。

COPY Bulk Data Transfer 構文


   
    sql format: 
    COPY _table[(_column1, _column2 ...)] from '_path' [WITH] _options;

 
    JDBC case:
    statement.execute("COPY public.t_copy2 from 'D:\\DB\\CSV\\t_copy2.csv' WITH DELIMITER ',' CSV HEADER");

 
    .NET case:
    DbCommand dbCommand = conn.CreateCommand();
    dbCommand.CommandText = "COPY public.t_copy2 from 'D:\\DB\\CSV\\t_copy2.csv' WITH DELIMITER ',' CSV HEADER";
    int count = dbCommand.ExecuteNonQuery();

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8397