This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 185452

Summary:	format query
Product:	db	Reporter:	nbphpuser <nbphpuser>
Component:	SQL Editor	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	P3
Version:	-S1S-
Hardware:	PC
OS:	Windows XP
Issue Type:	ENHANCEMENT	Exception Reporter:

Description nbphpuser 2010-05-04 16:18:53 UTC

It would be great if NB could format queries. 

If you copy paste some long query as one line it is difficult to edit and inspect it. Editor could make great job if it does some basic formating like below:


select a, b, c from sometable where a=1 order by b limit 1;

format into:

SELECT
 a, 
 b, 
 c 
FROM sometable 
WHERE a=1 
ORDER BY b 
LIMIT 1;

Comment 1 matthias42 2012-05-17 11:06:30 UTC


*** This bug has been marked as a duplicate of bug 155167 ***