Professional Web Applications Themes

Simple syntax question - MySQL

Hi I don't remember how to get the diplayed result broken in multiple lines. The command: mysql> SHOW INDEX FROM recentchanges; gives one very large line that wrapped over the screen. I think that using another character instead of ; for termination would give one line per field. Thanks...

  1. #1

    Default Simple syntax question

    Hi

    I don't remember how to get the diplayed result broken
    in multiple lines.

    The command: mysql> SHOW INDEX FROM recentchanges;
    gives one very large line that wrapped over the screen.

    I think that using another character instead of ; for
    termination would give one line per field.

    Thanks
    Hompf Guest

  2. #2

    Default Re: Simple syntax question

    Hompf wrote:
    > Hi
    >
    > I don't remember how to get the diplayed result broken
    > in multiple lines.
    >
    > The command: mysql> SHOW INDEX FROM recentchanges;
    > gives one very large line that wrapped over the screen.
    >
    > I think that using another character instead of ; for
    > termination would give one line per field.
    >
    > Thanks
    Just type
    mysql> help
    and you get several lines, among which, this one:
    ....
    ego (\G) Send command to mysql server, display result vertically.
    ....

    ciao
    gmax


    --
    _ _ _ _
    (_|| | |(_|>< The Data Charmer
    _|
    [url]http://datacharmer.blogspot.com/[/url]
    Giuseppe Maxia Guest

  3. #3

    Default Re: Simple syntax question

    Giuseppe Maxia wrote:
    > Hompf wrote:
    >> Hi
    >>
    >> I don't remember how to get the diplayed result broken
    >> in multiple lines.
    >>
    >> The command: mysql> SHOW INDEX FROM recentchanges;
    >> gives one very large line that wrapped over the screen.
    >>
    >> I think that using another character instead of ; for
    >> termination would give one line per field.
    >>
    >> Thanks
    >
    > Just type
    > mysql> help
    > and you get several lines, among which, this one:
    > ...
    > ego (\G) Send command to mysql server, display result vertically.
    > ...
    Thanks
    I was googling instead and loosing much time.
    Hompf Guest

Similar Threads

  1. dummy here needs simple MySQL syntax help
    By Lossed in forum Coldfusion Database Access
    Replies: 1
    Last Post: February 10th, 03:03 AM
  2. simple syntax issue?
    By geo in forum Adobe Flash, Flex & Director
    Replies: 0
    Last Post: February 2nd, 10:47 AM
  3. Simple ANSI syntax Outer Join question
    By Captain Special in forum Coldfusion Database Access
    Replies: 11
    Last Post: December 14th, 03:59 PM
  4. Simple PHP Headers Syntax Question
    By jip in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 8th, 04:41 PM
  5. Simple Perl code/syntax question
    By Wiggins D Anconia in forum PERL Beginners
    Replies: 0
    Last Post: January 23rd, 03:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139