Formating INSERT statement in DataGrip
Answered
Is it possible to automatically align INSERT statement code using code formatting in DataGrip.
I would like INSERT INTO Table (Col1, Col2) VALUES ('a', 1), ('bb', 22), ('ccccc', 33333);
would be formated into
INSERT INTO Table
(Col1, Col2)
VALUES ('a', 1)
, ('bb', 22)
, ('ccccc', 33333);
Please sign in to leave a comment.
You can configure many parameters in Preferences/Settings | Editor | Code Style | SQL | General | Queries.
Pay attention to INSERT statement and VALUES clause options.
Unfortunately I can't make it.
I want to have insert values as table:
Gotcha. Please follow DBE-13187.