Configuration:
Emacs 25.0.50 on Ubuntu 15.04.
How to produce?
Do emacs -Q
, then M-x sql-mode
.
Paste the following in the buffer:
SELECT SUM(T01.foobar) FROM db_foo.bar T01 WHERE T01.fooID = 1 AND T01.barID = 2 AND T01.foo IS NOT NULL'
When I do C-x h, and then M-x indent-region
, it says the
indent region is done. But the SQL statement is indented in an another way:
SELECT SUM(T01.foobar)
FROM db_foo.bar T01
WHERE T01.fooID = 1
AND T01.barID = 2
AND T01.foo IS NOT NULL
I would like to change the indentation it in the following:
SELECT SUM(T01.foobar)
FROM db_foo.bar T01
WHERE T01.fooID = 1
AND T01.barID = 2
AND T01.foo IS NOT NULL
So I decided to change the indentation myself. When looking on the source code of SQL mode, I don't see any hints where I could change the indentation for words and for "AND".
Any suggestion how I could change the indentation of SQL string?