Change Line Comment Character

Answered
Avatar
Permanently deleted user
Created

How can I change the line comment in a SQL file from # to -- in DataGrip? 

Votes

4

Share

4 comments
Avatar
Andrey Dernov
Created

There is no setting to control comment character. Every SQL dialect uses it's own. For example Generic or Oracle dialects use `--`, in MySql it is `#` character.

2
Avatar
Permanently deleted user
Created

Great. Thanks so much for the response.

0
Avatar
Permanently deleted user
Created

MySQL supports both # and -- single line comment styles. If you edit code in more than one IDE and they don't agree on which to use then it can be painful. I guess it's not a terribly high priority feature, but it would be useful to be able to specific which single line comment style to use.

1
Avatar
vasily chernov
Created

@...,

There are a number of issues that met your description, e.g. https://youtrack.jetbrains.com/issue/DBE-5911

 

For more https://youtrack.jetbrains.com/issues/DBE?q=comment%20styles%20%23Unresolved

0

Please sign in to leave a comment.