How to specify terminal width in mysql CLI

Question

I am using the mysql CLI, but the result is always displayed on my terminal screen. is there any way to tell mysql the size of my terminal screen?

Answer 1

I could not find the team resize, but stty cols 150worked for me. You will need to run this command in a bash terminal before entering the mysql command line client.

Answer 2

MySQL does not seem to have parameters for the terminal line. If you use the system using ksh or bash, try the following before starting the mysql command shell:

eval `resize`

[ , ] $COLUMNS $LINES , xterm , .