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

by

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 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)