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
- don't create an CREATE TABLE statement
- Use the following Tablename
Did i have not found an configuration value to replace the MY_TABLE name ?
Please sign in to leave a comment.
still no one konw how to slove this ??
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.