blob: 8180cf0b29ce6b866f83a476d67b2f97de83177a (
plain)
1
2
3
4
5
6
7
8
9
|
CREATE TABLE {{{tablePrefix}}}{{tableName}}{{{tableSuffix}}}
({{#each_with_index columns}}{{#if index}}, {{/if}}{{{../fieldPrefix}}}{{name}}{{{../fieldSuffix}}} {{db_type}}{{/each_with_index}})
{{separator}}
INSERT ALL {{#each_with_index data}}
INTO {{{../tablePrefix}}}{{../tableName}}{{{../tableSuffix}}} ({{#each_with_index r}}{{#if index}}, {{/if}}{{{../../fieldPrefix}}}{{column_name_for_index ../..}}{{{../../fieldSuffix}}}{{/each_with_index}})
VALUES ({{#each_with_index r}}{{#if index}}, {{/if}}{{formatted_field ../..}}{{/each_with_index}}){{/each_with_index}}
SELECT * FROM dual
{{separator}}
|
