PhpStorm 2019.1 Help

Work with query results

When you run a query in the console, you receive results in the table format. Each statement appears in a separate tab in the Database Console tool window. For example, if you have two SELECT statements in the query, you will see two tabs in the tool window.

Open a new tab for each query

By default, PhpStorm updates the same tab with results each time you run a query. You can change this behavior and create a tab each time you run a query.

  1. In the IDE settings (Ctrl+Alt+S), go to .

  2. Select the Open results in new tab checkbox and click OK.

Edit values in the result set

  1. In the result set, click a cell value that you want to edit.

  2. Specify a new value and press Enter.

  3. To submit changes to a database, click the Submit icon (The Submit icon), or press Ctrl+Enter.

Modify values in the result set

Export to a file

  • Right-click a, select Dump Data | To File.

  • Right-click a query, click Execute to File and select the file type that you want to use for export (for example, Comma-separated (CSV)).

  • On the toolbar, click the Dump Data icon (The Dump Data icon) and select To File.

Export a view to a file

Export to a clipboard

  • Select data in the result set or in the editor and press Ctrl+C.

  • On the toolbar, click the Dump Data icon (The Dump Data icon) and select To Clipboard.

Export a view to the clipboard

Compare two result sets

  1. Select a result set.

  2. Click the Compare with icon (The Compare with icon), and select another result set.

  3. If needed, change a value of the Tolerance parameter in the comparison dialog. The Tolerance parameter defines a maximum number of differences that are allowed between two result sets. For example, if you want to consider two rows as equal if their data differs in a single column, enter 1 in the Tolerance field.

Compare result sets
Last modified: 16 April 2019