开发者

MySQL: How to set Linesize and other environment parameters

开发者 https://www.devze.com 2023-02-20 09:25 出处:网络
I need to set linesize to some queries I perform which are quite important. Does anyone kn开发者_如何学Goow how?If you are looking for an equivalent output formatting in MySQL to Oracle\'s linesize &a

I need to set linesize to some queries I perform which are quite important. Does anyone kn开发者_如何学Goow how?


If you are looking for an equivalent output formatting in MySQL to Oracle's linesize & pagesize, I would suggest using raw output mode. If you need line wrapping at a certain length rather than the full unwrapped line, you can pass it through a command line utility such as Unix fmt:

echo "SELECT col1, col2 FROM tab1;" | mysql --raw --batch -uuser -p dbname | fmt --width=80
0

精彩评论

暂无评论...
验证码 换一张
取 消