Select the isolation level for database transactions and the way the transactions are committed.Īuto: the current transaction is committed automatically when you submit your local changes to the database server. For more information about submitting and reverting changes, see Submit changes to a database. Submit local changes to the database server. Preview DML of changes that you made to the table. You can select a scope of different cells and revert values in this scope.įor more information about reverting changes, see Submit changes to a database. Revert changes that you made to a cell value. Also, you can press Control and click the necessary rows. To select multiple rows, click numbers in the gutter. Terminate execution of the current statement or statements.įor more information about working with rows, see Tables. Select, pause, or disable update interval for the current table. Also, use the Reload Page button when you want to apply a new page size limit setting after its change. Reload data for the table view to synchronize the data that you see in the editor with the contents of the database. Alternatively, to disable the page size restriction, clear the Limit page size to checkbox. In the Limit page size to field, type a new size of a result set page. Alternatively, open settings ( Control+Alt+S) and navigate to Database | Data Editor and Viewer. To change the size of a result set page, click the Change page size button and select the size. You can change it here by clicking and selecting the necessary limit or in settings. You can see the limit between the navigation buttons. If all the rows are currently shown, navigation icons and the corresponding commands are inactive. If this number is less than the number of rows in the table, only a subset of all the rows is shown at a time. Use navigation icons and corresponding commands for switching between pages that show the table data and change the page size.Ī number of rows that you see on the toolbar are referred to as a result set page. Most of the available functions are accessed by means of controls on the toolbar, context menu commands for the data cells, and associated keyboard shortcuts. You can also navigate between related rows, between subsets of rows, or go to a specified row.įor full information on these and oter features, refer to Rows. Manipulate the rows by adding, deleting, cloning them, and so on. For MongoDB, the default extractor is always JSON.įor more information about data extractors, refer to the corresponding page.įor more information on how to export data in DataGrip, refer to Export data. The last selected extractor becomes the default one for newly opened editor tabs. You can use a built-in data extractor, configure a custom extractor that is based on CSV or DSV format, and create a custom data extractor using a provided API. Each time you export or copy data, the copied data format is defined by the selected data extractor. Export dataĭataGrip uses data extractors to export data in various formats to a file or the clipboard. Use one of the following ways to filter data:Įnter a filtering query into the corresponding field.įor full information, refer to Filter data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |