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

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

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

Re: MYSQLOUTPUT

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