Hi,

I was just wondering if there is any tool or a way to display tables in Linux console so that they are not messed up like this:

MariaDB [test]> select * from tabeleczka;
+------+------------+---------------+-----------------+--------------------
---------------------+
| lp | name | surname | age | jklvgjkdrlxhgxkldgh
xkldgjkklgdxjfgkldfg |
+------+------------+---------------+-----------------+--------------------
---------------------+
| 1 | bozydarnik | jkojglsjgsdjg | stopiecdziesiat | fjaklsegjsklghsdkjg
haskjghasdgasg |
+------+------------+---------------+-----------------+--------------------
---------------------+



i would like to achieve something that actually looks like a table. Is it possible?

Sure, don't use it from the mysql > prompt and issue something similar to

Hey, I've got the same result by invoking the command from shell directly.

It looks funky because the lines wrap. Try using the \G switch which causes each column to be on it's own line.

I don't know if there is a switch in mysql to stop line breaks, although I imagine it's your linux terminal that's wrapping the lines.

You are displaying a ~114 character width table in an 80 character wide terminal... something has to wrap!

You could run the query from a shell as Habitual says then pipe it through a formatting script of your own making, or turn the corner with \G per Doug G, to get some desired formatting. Alternatively, you could write a script to fetch and iterate the result and write it in formatting of your choice.

But MySQL/MariaDB is all about the data, you have to structure the query itself to return the data formatted or pipe it through a formatting filter.

Is it possible to output that to a file and read it from there or would that be counter-intuitive??

To the file, nice.
Thanks