In DataGrip, as in other IntelliJ-based IDEs, everything is about source editing. What you want can be achieved this way: Open console Start typing sel, you’ll get completion popup (if not, hit Ctrl+Space) Choose sel here, which is live template for SELECT statement SELECT statement will be generated, asking for table name and column list … Read more
You can either: Select the field, right-click, and select “Set NULL” Select the field, press CTRL+ALT+N (on Windows). Note that boolean fields will show up as a box filled with a dash (-) when null. If the “Set NULL” option is not appearing, you might need to refresh the schema which you can do by … Read more
Choose SQL Insert extractor in the drop-down menu. Them you’ll be able to copy (Ctrl/Cmd+C) data as a bunch of INSERTS. Or use Export button next to the extractor.
In DataGrip as other intellij-based IDEs everything is about source editing. So that can be achieved that way: Open console Start typing sel, you’ll get completion popup (if not, hit Ctrl+Space) Select sel here, which is live-template for select statement Select statement will be generated, asking for table name and column list Select desired table … Read more
In DataGrip go to File > Open and select your mysql dump file. Then right click the tab for the file to get the context menu, and select “Run [your filename…]” option. It may ask you to select your schema to apply the run to. But this is how I accomplished importing a dump from … Read more
Coming back here two years later, it seems to be not possible anymore to change the advanced properties in the connection settings. Instead you have to supply sys as sysdba as username. (This might seem obvious but took me a while to find this out)
Click on page-size of the result-set
I am Max, the PMM of DataGrip. We usually say that DataGrip provides the same functionality as all the other IDE’s from JetBrains with the database support. As mentioned above, DataGrip provides better user experience as a standalone IDE.
In DataGrip 2017.1 UI for this was introduced
Old thread here, but for those who may stumble upon it, the newer versions of DataGrip have a new option, “dump with mysqldump”, that will let you generate a dump contained in a single .sql output file.