Is it possible to auto-indent a query in mysql-worckbench

Question

I mean, something equivalent to simple formatting plugin that automatically indents code. Is there something in this sense?

Relevant: https://stackoverflow.com/questions/30938297/mysql-workbench-plugins-utilities-reformat-sql-query — Tim Biegeleisen, Oct 19 '17 at 06:23

score 18 · Accepted Answer · answered Oct 19 '17 at 06:29

18

Refer this link you will have Beautify Query option

select the query you want to format in editor and then do

Edit -> format -> Beautify Query

answered Oct 19 '17 at 06:29

RohitS

9

Short-cut: `Ctrl + B` – Julian May 31 '18 at 11:23
Tried Ctrl + B in windows/workbench. Didnot work for me. – Ariful Haque Oct 18 '18 at 14:42
I am using Workbench on Ubuntu 20.04. This option seems like it has formatted something when clicked. But nothing changed at all. – Deepam Gupta Oct 16 '21 at 10:14

score 1 · Answer 2 · edited Apr 29 '21 at 09:27

1

This Works:

Edit -> format -> Beautify Query

NOTE: You have to click it always, it does not happen on saving the Query.

Shortcut: Ctrl + B

edited Apr 29 '21 at 09:27

Tomerikoo

answered Apr 29 '21 at 01:44

majidshakeelshawl

score 0 · Answer 3 · edited May 15 '20 at 08:33

0

Following options are available:

edited May 15 '20 at 08:33

Nimantha

answered May 14 '20 at 10:47

sreerag

3 Answers3