virtualsolver
asked on
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 ??
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 ??
ASKER
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
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
on shell prompt :
shell> mysql -uUSER -pPASSWORD -e "show status" > show_status.out
shell> vi show_status.out
shell> mysql -uUSER -pPASSWORD -e "show status" > show_status.out
shell> vi show_status.out
ASKER
so you guys saying
there is no way i can customized my output in mysql command line ??
there is no way i can customized my output in mysql command line ??
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
Right Click on Putty Titlebar
Goto Window
Reset Line of scrollback = 1000 or whatever you want.
<See Image>
putty.JPG
ASKER
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 ??
what about monitor ?? yes, i am using putty, but from monitor which is connected to the server, how will i set scrol in their ??
"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.
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.
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 ??
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 ??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Calling Zone-Admins:--
Can any 'Zone Expert' can edit my username password here??
Can any 'Zone Expert' can edit my username password here??
ASKER
ok that one should work
i am currently out of office, let me just check the commandi will come back
i am currently out of office, let me just check the commandi will come back
ASKER
~thanks
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