Modify data in your table without leaving the window. It works for any query result received from a table. Completion for values in the table is available via Ctrl+Space. It looks through all the values in the column and offers you a list of possible matches. Submit changes using Ctrl+Enter.
All your changes in the data editor are stored locally and can be submitted all at once. Local changes are colored, so you can see which changes you are going to save, be it updating, inserting, or deleting rows. Submit with Ctrl+Enter. Ctrl+Alt+Z is for canceling, but works in a tricky way — only the selected changes are canceled. If you wish to cancel all of them, select all the cells with Ctrl+A before reverting.
Several fields can be edited at the same time — just select them and begin to type. Of course, it only works if the columns you are editing are not unique and have the same type.
Paste from CSV
Paste data from Excel tables. Generally to do this, you need the ability to paste data in a DSV format. In DataGrip you can define any format you want, or you can let the IDE detect the format automatically: Gear icon → Paste format and it’s done:
While updating data you can see which particular queries DataGrip is running. We have nothing to hide!
Use the filter text field to only see the data you need, without writing any
WHERE clauses. Just put the condition in this field in the appropriate SQL
Find data inside a table quickly without writing a statement thanks to text search, available in the Table Editor via Ctrl+F. It’s especially helpful if you don’t know which exact column contains the data you’re looking for. You can easily hide irrelevant rows, and regular expressions are available as well.
To search for data everywhere use Full-text search.
Define what kind of transaction control you want to use when working with data. The data editor in the Auto mode works like it's described in the Bulk Submit section.
In Manual mode there are also:
— Commit button or Shift+Ctrl+Alt+Enter: commits the transaction. If you have unsubmitted local changes (again, they are highlighted) they will be automatically submitted before the commit.
— Rollback button: rolls back a transaction if it’s uncommitted.
If the table contains too many columns to place on the screen, use the Transposed view to see the data from a particular row in a friendlier way.
Search for a column
Open Structure view by Ctrl+F12 and start typing! Speed search can help save you again by filtering the columns. Press Enter to navigate to a particular column.
Rich text edit
If you have, for instance, a lot of text inside the field, you can maximize the cell view by pressing Ctrl+Alt+Shift+M. Choose Active Editor: Use Soft Wraps from the Find Action menu if you'd like to have word wraps for viewing the text.
In case oj
JSON it'll be automatically formatted and highlighted.
Navigation by foreign keys
If a column contains a foreign key, you can navigate to the related data for a particular value or view it in the pop-up. In many situations this saves you from having to write a query.
On the opposite side, you can find usages of foreign keys in other tables. You will be navigated to the data referencing your row and column. If the cursor is on a column that is not referenced, then you can choose what data you want to navigate to.
Values of two or three cells can be compared in the Diff Viewer. Select them and press Shift+Ctrl+D.
Any table or result-set can be exported in a variety of formats including
HTML. You can even create your own
format to export to.
You can search for data even if you don’t know where it is located. To do this, select the data sources, groups of data sources or even separate tables you want to search through and invoke Full-text search from the context menu. Of course, there is a shortcut for this as well: Ctrl+Alt+Shift+F.
You will see a dialog to enter the string into. You will see the list of data sources to search through, and you’ll be able to set some options for your search.
In addition, you can see which particular statements DataGrip will run to perform the data search.
After running the search, you’ll see the results which you can open.
Click on a result to open the data editor. The filter will be pre-defined to give you only those strings where the data is found. If you cannot locate the data because there are too many columns, use text search in the data editor with Ctrl+F.