Re: MYSQLOUTPUT

2004-04-01 Thread Rhino
alent 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

Re: MYSQLOUTPUT

2004-04-01 Thread Seena Blace
Victor I want output like noname amt 1 10 20 instead of below noname amt 1 10 1 20 thx Victor Pendleton <[EMA

Re: MYSQLOUTPUT

2004-04-01 Thread Victor Pendleton
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

MYSQLOUTPUT

2004-04-01 Thread Seena Blace
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