client - mysql --quick option -
when run mysql --quick option suggested in web posting desc <table> returns lot of --
whereas when run mysql without --quick option desc table returns normal output.
table has 7 columns...6 doubles , 1 date col.
thank raman
--quick: not cache each query result, print each row received
which means if describe table, , mysql wants pretty print (you now, |'s between fields, , -'s around header & bottom), not know yet how long each field in resultset going be, assumes largest width column may 'boxing'. if @ information_schema.columns, can see instance column_comment varchar(1024), fields add up. may seem -'s, 'bottom' of boxing, if scroll (assuming scrollback big enough), you'll see desired data there.
you can:
- use \g delimiter vertical output rather boxed.
- start process automatic vertical output
--auto-vertical-output - start process non-tabular / non-boxed output
mysql --quick -s
Comments
Post a Comment