Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I convert a Java SQL String to SQL in Datagrip?

Tags:

java

sql

datagrip

I have a statement in my Java code like so

String sql = "SELECT COL1, COL2, COL3, " +
             " COL4, COL5, COL6, COL7 "  +
             " FROM TABLE T";

Is there an easy way to convert/format this as a SQL query (like below) in Datagrip. Similar to what SQLWorkbench does with a "Clean Java Code" by pressing Alt+L?

SELECT COL1, COL2, COL3,
       COL4, COL5, COL6, COL7 
       FROM TABLE T
like image 879
Java Devil Avatar asked Nov 26 '25 11:11

Java Devil


1 Answers

  1. Put the caret on the string literal
  2. Press Alt+Enter
  3. Choose Copy string concatenation text to clipboard List item
like image 186
moscas Avatar answered Nov 28 '25 23:11

moscas



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!