Re: ORDER BY WITH NO PRINT

2004-04-18 Thread Tobias Asplund 
On Fri, 26 Mar 2004, Seena Blace wrote:

 Select group,hostname,details from table1 order by group;

 I want the output should be like
 Group   hostname   details
 aa   abababa
   abababababab
   anannanananna
 bbllololololool

Hi Seena,

Try this:

SELECT IF(@a != group, @a := group, '') AS group, hostname, details FROM
table1 ORDER BY group

Cheers,
Tobias

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER BY WITH NO PRINT

2004-03-30 Thread Seena Blace 


Seena Blace [EMAIL PROTECTED] wrote:Hello,
I want to show outpur like this?
Group hostname details
aa  abababa
aa  abababababab
aa  anannanananna
bb  llololololool
bb  ssjjsjsjsjjsjsj

Select group,hostname,details from table1 order by group;

I want the output should be like 
Group hostname details
aa  abababa
 abababababab
 anannanananna
bb  llololololool
 ssjjsjsjsjjsjsj



please advice.
thx -seena


-
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.


-
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.

RE: ORDER BY WITH NO PRINT

2004-03-27 Thread JOHN MEYER 
This may sound a little bit off, but what programming language are you using 
to print this.  It might be easier to simply use a language like perl to 
print out the output that you are suggesting.


From: Seena Blace [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: ORDER BY WITH NO PRINT
Date: Fri, 26 Mar 2004 19:33:44 -0800 (PST)
Hello,
I want to show outpur like this?
Group   hostname   details
aa   abababa
aa   abababababab
aa   anannanananna
bbllololololool
bbssjjsjsjsjjsjsj
Select group,hostname,details from table1 order by group;

I want the output should be like
Group   hostname   details
aa   abababa
      abababababab
      anannanananna
bbllololololool
   ssjjsjsjsjjsjsj


please advice.
thx -seena
_
Get tax tips, tools and access to IRS forms – all in one place at MSN Money! 
http://moneycentral.msn.com/tax/home.asp

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ORDER BY WITH NO PRINT

2004-03-26 Thread Seena Blace 
Hello,
I want to show outpur like this?
Group   hostname   details
aa   abababa
aa   abababababab
aa   anannanananna
bbllololololool
bbssjjsjsjsjjsjsj
 
Select group,hostname,details from table1 order by group;
 
I want the output should be like 
Group   hostname   details
aa   abababa
      abababababab
      anannanananna
bbllololololool
   ssjjsjsjsjjsjsj

 
 
please advice.
thx -seena


-
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.