From: Jason Pyeron Date: September 2 2005 8:33pm Subject: Re: 2 query questions List-Archive: http://lists.mysql.com/mysql/188658 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed please write 2 emails for 2 unrelated questions, that said I will tackle #2 you have all those line drawing chars since the field is very wide. The MySQL client does not 'know' about new lines, it just prints them out, so each one is counted as one char. in your client you can ask for help, \?, ?. Look at the command \G or ego; it will display your results vertically, avoiding this issue. On Fri, 2 Sep 2005, YL wrote: > (2) when using mysql command to query a value of type text, the displayed > value always surrounded by lots > '-'s. My question is: How to get rid of those extras? (The following is a > tail of display result:) > template = { > b5 = resources/articles/_backups/subIndex_b5.template; > gb = resources/articles/_backups/subIndex_gb.template; > }; > }; > }; > > |--------------------------------------------------------------------------- > -------------------------------------------- > ---------------------------------------------------------------------------- > ------------------------------------------- > ---------------------------------------------------------------------------- > ------------------------------------------- > ---------------------------------------------------------------------------- > ------------------------------------------- > ---------------------------------------------------------------------------- > ------------------------------------------- > ----------------------------------------------------------+ > > > -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner & Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited.