How to customized mysql command line output

Hi
in mysql command line, if i type

show status

its gives a long output , so i cant see the first few records because of long result.
which command shall i use to make it page by page , like in linux we use , ls -l | less . is there any command in for mysql command line to make it page by page ??
virtualsolverAsked:
Who is Participating?
 
theGhost_k8Database ConsultantCommented:
:) Everything made sense !!

Okay now I was just trying to make it possible any how..
One was Linux way, Other was PuTTY way...

And here is mysql way:-
mysql -uusername -ppassword  --pager=more

I hope Author has got the answer ;)
0
 
BALMUKUND KESHAVCommented:
which client software are you using to connect to mysql databse ?
If you are using SqlYog or MysqlAdmin there is setting for no.of records to be displayed in result set.
Set appropriately or take output in csv/Xls/XML file

Regards,

Bm Keshav

0
 
virtualsolverAuthor Commented:
HI thanks
I am using Mysql Command line, i have install mysql 5 in linux server so i am accessing it from command line like this

mysql -p
-> password
so i have intered mysql command line

Myql>show status

its giving me long result, so i cant view previous result, i want to make it page by page

check the picture how i am trying to access

mysqlserver.GIF
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
theGhost_k8Database ConsultantCommented:
on shell prompt :

shell> mysql -uUSER -pPASSWORD -e "show status"  > show_status.out
shell> vi show_status.out
0
 
virtualsolverAuthor Commented:
so you guys saying
there is no way i can customized my output in mysql command line ??
0
 
theGhost_k8Database ConsultantCommented:
Here you are using Putty and if you want to do a scroll up and see the results:

Right Click on Putty Titlebar
Goto Window
Reset Line of scrollback = 1000 or whatever you want.

<See Image>


putty.JPG
0
 
virtualsolverAuthor Commented:
haha LOL

what about monitor ?? yes, i am using putty, but from monitor which is connected to the server, how will i set scrol in their ??
0
 
theGhost_k8Database ConsultantCommented:
"LOL" !!!??

Monitor has no role to play here!!
Change the settings, you will get 1000 lines - scrollbar and you will be able to scroll back that much.
Will suffice your requirement.
0
 
fosiul01Commented:
sorry for laughing, i realy appreciated the answer you gave , but that solution does not satisfy the full problem..

omm let me explain properly , forget putty. because this one is in vmware environment so i had to use putty

i have mysql server installed on proper physical server which has a monitor aswell
i am standing infront of  that server
and i have executed " show variables " commadn which returned 256 row which impossilbe to fit in one screen. so  i cant see the first few records

thast why i want to know how can you customized this output to see page by page ..  


does it make sense ??

0
 
theGhost_k8Database ConsultantCommented:
Calling Zone-Admins:--

Can any 'Zone Expert' can edit my username password here??
0
 
virtualsolverAuthor Commented:
ok that one should work
i am currently out of office, let me just check the commandi will come back

0
 
virtualsolverAuthor Commented:
~thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.