How to output query result with CSV format? (DBMR: 1893, version: DBMaker 4.3.2 bundle)

~ 0 min
2016-03-08 09:49

Export command only provides syntax with basic table,

EXPORT [INTO data-file]

            TABLE table-name

            [DESCRIPTION description-file]

            [LOG log-file]

            [STOP_ON_ERROR],

and does not support export query result.

Considering performance, they can create a view to replace that query result.

For example:

 (1) Create view v2 as select * from t1 inner join t2 on t1.c1 = t2.c3;

 (2) export into tmp.csv table v2 description tmp.des;

The view is dynamic and will be executed when be used, so exporting CSV format file will not do additional action, so the performance should be better than creating temporary table method.

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags