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
