emacs-edbi icon indicating copy to clipboard operation
emacs-edbi copied to clipboard

Multiple queries possible?

Open ReneFroger opened this issue 9 years ago • 2 comments

Is it possible to use EDBI query editor with multiple queries like:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (foo1,foo2,foo3,...);
INSERT INTO table_name (column1,column2,column3,...)
VALUES (bar1,bar2,bar3,...);
INSERT INTO table_name (column1,column2,column3,...)
VALUES (foo4,foo5,foo6,...);
INSERT INTO table_name (column1,column2,column3,...)
VALUES (bar4,bar5,bar6,...);

Instead one query to evaluate per once in EDBI query editor?

ReneFroger avatar Feb 21 '16 21:02 ReneFroger

It is not possible in the current implementation. If the region is activated in query editor, the selected SQL would be executed.

I also need the multiple SQL execution, but the displaying results is little difficult problem, rather than SQL parsing.

kiwanami avatar Feb 22 '16 04:02 kiwanami

What about displaying the result of the latest query?

For example, you have two queries that deletes records. EDBI result window will display the latest stdout from the latest query.

ReneFroger avatar Mar 12 '16 18:03 ReneFroger