I am looking for possibility to generate batch of queries (insert/update/..).
I have a list of data which I would like insert:
and I would like to achieve this:
INSERT INTO MY_TABLE (COLUMN) VALUES ('123');
INSERT INTO MY_TABLE (COLUMN) VALUES ('234');
INSERT INTO MY_TABLE (COLUMN) VALUES ('2345');
INSERT INTO MY_TABLE (COLUMN) VALUES ('435');
For the moment, I am using Notepad++, where I am recording macro for one row and then I am running macro till end of file or I am setting number of executions.
I have discovered that DataGrip has a possibility to record macro, but macro can be run only once.
So, for each line I need to go to Menu-->Edit-->Macros-->Play Back Last Macro.. (btw. I haven't found possibility to customize toolbar, that macro can be easily accessible, is there any?).
Or maybe there is other workaround?