how to specify the terminal width in mysql CLI

Question

I'm using the mysql CLI, however the result displays always wraps around on my terminal screen. is there any way to specify to mysql the size of my terminal screen?

Answer 1

MySQL doesn't seem to have any settings for terminal linesize. If you're on a system with ksh or bash, try the following before launching the mysql command shell:

eval `resize`

[note the quotes are backticks] This should set the $COLUMNS and $LINES shell variables to the size of your window and ensure that the xterm knows how big it is.

Answer 2

that approach doesn't seem to work for me