Skip to content

Export sql doesn't name insert columns #242

@galmok

Description

@galmok

When exporting the database to SQL with the purpose of importing the data from one of the tables via SQL to another database, it would be extremely helpful if the columns were named in the INSERT statement. This would make the insert work even if the columns were in a different order in the target database (my situation),

I can solve it by replacing the INSERT word like this:

INSERT INTO SomeData VALUES (1,34,37,463);
to:
INSERT INTO SomeData (col1,col2,col3,col4) VALUES (1,34,37,463);

I would be nice if this tool could do this automatically.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions