format SQL->select statement?

[expired user #9650]'s profile image [expired user #9650] posted 8 years ago in General Permalink

hi,could you update the SQL VIEW,espaciall the SELECT STATEMENT of the SQL,for example: the current SQL format is:

SELECT acct.ACCT_ID,acct.ACCT_NAM,acct.ACCT_CD FROM fund_acct acct WHERE acct.ACCT_ID = 1

could you update it to the following example:

SELECT acct.ACCT_ID, acct.ACCT_NAM, acct.ACCT_CD FROM fund_acct acct WHERE acct.ACCT_ID = 1

or can we edit the format ourself?

[expired user #9650]'s profile image [expired user #9650] posted 8 years ago Permalink
2 attachment(s):
  • Image-3
  • Image-2
[expired user #9650]'s profile image [expired user #9650] posted 8 years ago Permalink

the second image is the better sql format I think.Or could we edit the SQL format by ourself?

[expired user #9650]'s profile image [expired user #9650] posted 7 years ago Permalink

anyone could solve the important question? nobody pay attention to the SQL format? It's very important for a good sql manager tool~

kalvaro's profile image kalvaro posted 7 years ago Permalink

I don't think it's so straightforward. I often handle queries that retrieve many columns and using a line for each column would force a multiple-screen vertical scroll that would seriously harm legibility.

Many SQL tools allow to fully configure SQL format but that leads to huge configuration dialogues. Given that HeidiSQL is not really an IDE, I'd vote to keep it simple enough. In this case, the compromise could be to take SQL pane width into account and wrap lines only if they'd require horizontal scroll.

Please login to leave a reply, or register at first.