From: Rick Pasotto
Date: January 15 2001 5:03pm
Subject: Re: display width in mysqlgui
List-Archive: http://lists.mysql.com/mysql/61801
Message-Id: <20010115120333.J5599@tc.niof.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> Rick Pasotto wrote:
> > 
> > SELECT concat(last_name,", ",first_name) as name from members
> > 
> > results in a column that is much wider than necessary. Adding trim() to
> > the concat() nor to the components makes any difference.
> > 
> > Can the column width be specified?
> > 
> > --
> It doesn't for me.
> What table type, and field types are you using?

varchar(30)

Did you notice that I said 'mysqlgui' and not 'mysql'?

-- 
"Moderation in temper is always a virtue; but moderation in
 principle is always a vice."
		-- Thomas Paine, _The Rights of Man_ (1791)
		   Rick Pasotto email: rickp@stripped