Database Result Export MY_TABLE

The Database result and export "create instert statemement"  is a really nice Feature.

We are able to get an clear insert Statement.

During leftJoins
i.e.
SELECT
    cat.cat_id,
    art.art.id
FROM  categoryf AS cat
LEFT JOIN article AS art
      ON cat.product_id = art.product_id

the create Insert Statemenent looks like

CREATE TABLE MY_TABLE (
....
.....
);

INSERT INTO MY_TABLE(....., ....) VALUES (.....,.....);

Perhaps it is possible to tell the exporter

  1. don't create an CREATE TABLE statement
  2. Use the following Tablename


Did i have not found an configuration value to replace the MY_TABLE name ?

0
2 comments

still no one konw how to slove this ??

0
This issue has been reported here:

https://youtrack.jetbrains.com/issue/DBE-19828/Add-option-to-omit-schema-name-from-export-to-SQL-inserts

Please follow this issue to stay updated on the progress.
0

Please sign in to leave a comment.