Working With PHPStom IDE: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:PHP Category:Web Development == Misc == === Running SELECT queries outside the database console === '''Problem:''' If you simply '''Run''' a SQL query conta...") |
|||
| Line 6: | Line 6: | ||
'''Problem:''' If you simply '''Run''' a SQL query containing a SELECT statement outside the Database Console, i.e. open a .sql file and execute it, the Results Pane does not appear. | '''Problem:''' If you simply '''Run''' a SQL query containing a SELECT statement outside the Database Console, i.e. open a .sql file and execute it, the Results Pane does not appear. | ||
'''Solution:''' With the .sql file in focus, hit <kbd>Ctrl</kbd>+<kbd>Enter</kbd> to execute the script. I don't know what command in the menu this corresponds to, but it does open the Results pane, where ''right click'' > '''Run''' will not open the results pane. | '''Solution:''' With the .sql file in focus, and all of the SQL to executed selected in the editor, hit <kbd>Ctrl</kbd>+<kbd>Enter</kbd> to execute the script. I don't know what command in the menu this corresponds to, but it does open the Results pane, where ''right click'' > '''Run''' will not open the results pane. | ||
Latest revision as of 16:43, 23 September 2015
Misc[edit]
Running SELECT queries outside the database console[edit]
Problem: If you simply Run a SQL query containing a SELECT statement outside the Database Console, i.e. open a .sql file and execute it, the Results Pane does not appear.
Solution: With the .sql file in focus, and all of the SQL to executed selected in the editor, hit Ctrl+Enter to execute the script. I don't know what command in the menu this corresponds to, but it does open the Results pane, where right click > Run will not open the results pane.