CODEWITHSUNDEEP
mysqlterminalcommand-line-interface
jellosea
jellosea

Reputation: 31

how to specify the terminal width in mysql CLI

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?

Upvotes: 3

Views: 1784

Answers (2)

leodotcloud
leodotcloud

Reputation: 1960

I couldn't find resize command but stty cols 150 worked for me. You would have to execute this command in the bash terminal before you enter mysql command line client.

Upvotes: 2

Jim Garrison
Jim Garrison

Reputation: 86774

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.

Upvotes: 1

Related Questions