PhpStorm 7.0.0 Web Help

The results of executing an SQL command are reflected in the Output and Result panes. The Output pane displays information and error messages on the command execution. If the command supposes data retrieval, a new tab opens in the Result pane showing the retrieved records. For each command PhpStorm opens a separate tab.

Besides viewing and analyzing, you can update the retrieved records as necessary right in the corresponding Results tab, just like in the Table Editor.

To analyze the results of running SQL commands, perform these general steps
  • View the results of query execution in the Result tab. Results of each query are displayed in a separate tab.


  • To navigate between result sets, use the First Page dataSourceTableEditorFirstPage.png, Last Page dataSourceTableEditorLastPage.png, Previous Page dataSourceTableEditorPreviousPage, and Next Page dataSourceTableEditorNextPage.png toolbar buttons.
  • To refresh the current page after editing or resorting the table data, click the Reload Page toolbar button refresh.png.
  • To copy the values from a result, click the Copy button copy.gif on the toolbar of the corresponding tab or press the Ctrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+Insert, Alt+C or Escape, WCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCommand C or Command InsertCommand C or Command InsertCommand C or Command Insert shortcut.
  • To copy the query that produced a particular result, click the Copy Query button icon_sqlOpenInEditor.png on the tool bar of the corresponding tab or press the Ctrl+Shift+Alt+CCtrl+Shift+Alt+CCtrl+Shift+Alt+CCtrl+Shift+Alt+CCtrl+Shift+Alt+CCtrl+Shift+Alt+CCtrl+Shift+Alt+CCtrl+Shift+Alt+CShift Alt Command CShift Alt Command CShift Alt Command C shortcut.
  • View query execution details and error messages in the Output tab.
To update the queried table, perform these general steps
  • To update a record, select the corresponding row and modify the values as necessary.
  • To add a record, click the Add New Row toolbar button add.png and fill in the fields.
  • To remove one or several records, select the corresponding rows and click the Delete Selected Rows toolbar button delete.png.

See Also




Web Resources: