How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Insert into Question

[This topic is migrated from our old forums. The original author name has been removed]

Hello Roger! I'm exporting all the value from my table ACTIVITY.MAPPINGS for example: @export on; @export set filename="C:\test.sql" appendfile="true" format="sql"; select * from ACTIVITY.MAPPINGS ; And receive: insert into ACTIVITY.MAPPINGS (TYPE, CODE) values ('MEDT1', '1'); insert into ACTIVITY.MAPPINGS (TYPE, CODE) values ('MEDT1', '2'); insert into ACTIVITY.MAPPINGS (TYPE, CODE) values ('MEDT1', '3'); insert into ACTIVITY.MAPPINGS (TYPE, CODE) values ('MEDT2', '4'); HOW and what should I do to get only 1 time of "INSERT INTO", just like this kind of: insert into 'ACTIVITY.MAPPINGS' values ('MEDT1', '1') , ('MEDT1', '2') , ('MEDT1', '3') , ('MEDT2', '4') HELP please Thanks!
2 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: Insert into Question
Elias, It is currently not possible to structure the generated SQL to perform multi row inserts with a single insert statement. I will add your vote for this feature enhancement. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Insert into Question
thanks Cuz it'll save lots of space and time!!
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics