How to default emacs sql-mode comments to c-style?

Question

Does anyone know how to set Emacs to use /* */ comments in SQL mode by default instead of --?

Clarification: I want to insert /* */ when I type M-;, but by default it inserts --. I am not concerned with font coloring or anything.

I usually write sqlite and postgresql code, if that matters, but it shouldn't.

score 1 · Accepted Answer · answered Oct 10 '14 at 18:51

1

Something like

(add-hook 'sql-mode-hook
          (lambda ()
            (setq comment-start "/* ")
            (setq comment-end " */")))

might do it, tho it's 100% untested.

answered Oct 10 '14 at 18:51

Stefan

27,908
4
53
82

Works great -- thanks. I do wonder what happened to the hyphen comment syntax, though. – forkandwait Oct 10 '14 at 19:07
Sorry, but I don't understand what you mean by "what happened to the hyphen comment syntax". – Stefan Oct 10 '14 at 19:30
Oh, just curious about whether '--' is stored anywhere for easy access or if it just gets overwritten. No big deal, really, just curious. – forkandwait Oct 10 '14 at 19:31
No, I don't think it's stored anywhere for easy access. – Stefan Oct 10 '14 at 23:39

score -1 · Answer 2 · edited May 23 '17 at 10:33

-1

I don't know much about it, but I think you can edit the syntax table to change how emacs works. The answer on this thread explains it a lot better than I could, since I've never personally gotten to work with emacs. Aside from that, I unfortunately don't have anything for you. How to make Emacs sql-mode recognize MySQL #-style comments?

edited May 23 '17 at 10:33

Community

1
1

answered Oct 10 '14 at 17:18

PrincessTrevor

101
2

The question isn't how to recognize the syntax coloring, which is what the other answer addresses. – forkandwait Oct 10 '14 at 17:40

How to default emacs sql-mode comments to c-style?

2 Answers2