Can MySQL actually produce result sets like the ones Seena wants? In DB2, which I know a lot better than MySQL, DB2 doesn't produce such a result set by itself; you use a program like QMF to suppress the duplicate information on the rows and replace them with blanks.
Is there an equivalent program that works with MySQL? Or can MySQL do this by itself? I'm curious to hear the answer to this.... Rhino ----- Original Message ----- From: "Seena Blace" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 01, 2004 10:50 PM Subject: Re: MYSQLOUTPUT > Victor > I want output like > no name amt > 1 xxxx 10 > 20 > > instead of below > > no name amt > 1 xxxx 10 > 1 xxxx 20 > thx > > > > Victor Pendleton <[EMAIL PROTECTED]> wrote: > Are you just wanting to remove the header information? If so, then try > mysql --skip-column-names > > On Thu, 01 Apr 2004, Seena Blace wrote: > > > > Hi, > > > > I'm getting output like > > > > select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from > > host a,ipdet_temp1 b,makemodel c,software d,hsdet e > > -> where a.hostid=b.hostname2 and a.makemodel=c.makemodelid and > > a.hostid=e.host_id and e.software_id=d.softwareid and > > a.hostid='dstm-db01' and b.vflag='N' order by a.hostid; > > > > hostid | hdesc | ipadd1 | make > > | model | name | version | > > +-----------+------------------------+---------------+------------------ > > -----+-------+-----------+---------+ > > | box1 | Server1(DB01) | xxx.xxx.xxxx.xxx | Sun Micro System Inc. | > > E420R | Sun OS | 8 | > > | box1 | Server1(DB01) | xxx.xxx.xxxx.xxx | Sun Micro System Inc. | > > E420R | Oracle8i | 8171 | > > | box1 | Server1(DB01) | xxx.xxx.xxxx.xxx| Sun Micro System Inc. | > > E420R | DataGuard | 817 | > > +-----------+------------------------+---------------+------------------ > > -----+-------+-----------+--------- > > > > > > I want the output like > > +-----------+------------------------+---------------+------------------ > > -----+-------+-----------+---------+ > > | box1 | Server1(DB01) | xxx.xxx.xxxx.xxx | Sun Micro System Inc. | > > E420R |Sun OS |8 > > > > |Oracle8i |8171 > > > > DataGuard | 817 | > > +-----------+------------------------+---------------+------------------ > > -----+-------+-----------+--------- > > > > > > How to do this? > > thx > > > > > > --------------------------------- > > Do you Yahoo!? > > Yahoo! Small Business $15K Web Design Giveaway - Enter today > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > --------------------------------- > Do you Yahoo!? > Yahoo! Small Business $15K Web Design Giveaway - Enter today -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
