List:General Discussion« Previous MessageNext Message »
From:Jason Pyeron Date:September 2 2005 8:33pm
Subject:Re: 2 query questions
View as plain text  
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.
Thread
Trouble with revoke allScott Haneda2 Sep
  • Re: Trouble with revoke allGleb Paharenko2 Sep
    • Re: Trouble with revoke allScott Haneda2 Sep
      • Re: Trouble with revoke allMichael Stassen2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
          • Re: Trouble with revoke allMichael Stassen3 Sep
            • Re: Trouble with revoke allScott Haneda3 Sep
              • Multiple query execution (probably OT)Alvaro Cobo3 Sep
                • Re: Multiple query execution (probably OT)Gleb Paharenko3 Sep
                • How to migrate from V4.0.23 to V5?Siegfried Heintze4 Sep
                  • Re: How to migrate from V4.0.23 to V5?Gleb Paharenko5 Sep
      • Re: Trouble with revoke allGleb Paharenko2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
    • 2 query questionsYL2 Sep
      • Re: 2 query questionsJason Pyeron2 Sep
      • Re: 2 query questionsSGreen2 Sep
        • string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep
        • Re: string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep