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.
Reactions are currently unavailable
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.