Several fields can be edited at once - just select them and begin typing. If you wish to cancel all changes, select all cells with Ctrl+Abefore using Ctrl+Z. Ctrl+Zis for reverting, but works in a tricky way - only the currently selected changes are canceled. Local changes are colored, so you can see which changes you are going to save, be it updating, inserting or deleting rows. All your changes are stored locally and can be submitted at once. The grid is editable: when you observe table data, you can apply any changes just like you would in Excel. If you have two result-sets, they can be compared in Diff Viewer. Func(exp)means that the caret will be placed before the parentheses, not after.ĭataGrip lets you define what particular query you wish to execute after pressing Cmd/Ctrl+Enter: only a subquery, the whole statement where the caret is, or the whole script. To surround one query with another, or to make a common table expression, use the Surround Withaction by Cmd/Ctrl+Alt+T. For example ficafor film_category, or gabifor getAuthorByID.Įxpand column listlets you use the list of columns instead of wildcards. The IDE can complete your statement in a JOIN clause if the tables are connected with a foreign key.Ībbreviation completionlets you type abbreviations of database objects to use them in your code. We highlighted several types of code completion, the most interesting being abbreviation completion and JOIN statement completion. Live templates let you insert frequently-used or custom code constructs into your scripts. DataGrip supports the most popular databases, and will add supportfor Amazon Redshiftand Microsoft Azurethis July. All of DataGrip’s features are also available in other IDEs from JetBrains like IntelliJ IDEA, PhpStorm, P圜harm, RubyMine, as well as the upcoming Riderand Gogland. Navigation and search: Finding objects in the database, text in the source code, data in the table, column in the result-set.ĭataGrip is a standalone IDE for SQL based on IntelliJ Platform. Data extractors: Text extractors, SQL extractors, INSERTs batch editing, etc. Data editor: Bulk sumbit, multiple submit, foreign keys navigation, transpose view etc. Subqueries: Surround with, executing options, compare result-sets. Creating a simple query: Live templates, code completion, expand column list. Let me briefly describe what we talked about. We hope it all was useful for you and your feedback on the webinar is very welcome! Thanks to all who joined us and especially those who asked questions. We hosted our very first webinar on Wednesday, July 14th.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |