How to quickly generate SELECT statement for a table in DataGrip?

by

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 enter image description here
  • Select desired table from completion, as column list provide *
  • Then hit Alt+Enter on asterisk and select Expand column list enter image description here

I suggest you to look through https://www.jetbrains.com/datagrip/features/

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)