How do I get ctrl+enter to execute all SQL between semi-colons?
I'm having trouble with running statements like a CTAS that include a SELECT statement.
When I run ctrl+enter, DataGrip runs just the select clause, when I want it to run the entire CTAS. I've tried changing settings to run the 'largest statement' but that didn't work. Is there another setting I need to configure?
Please sign in to leave a comment.
1) When the cursor is placed on the subquery select and ctrl-enter is pressed, I get a window showing three options: execute the subquery, the ctas, or the entire procedure.
2) When the cursor is placed on the create statement and ctrl-enter is pressed, the window only has two options: the ctas or the entire script.
I don't get those options sometimes that include the full CTAS. It will highlight just the select clause, but not the entire command.
@ Brian Y Kim Hi,
Could you specify your Database -> Execute in Console settings? E.g.:
Thank you.