How to show mysql tables in one line? table\G less -SFX

option 1
select * from information_schema.key_column_usage\G where referenced_table_schema='employees';

option 2
mysql> pager less -SFX
mysql> SELECT * FROM sometable;
This will pipe the outut through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.
Leave this view by hitting the q key, which will quit the less tool.


Comments

Popular posts from this blog

HAproxy logging

teamcity Automatic Agent Start under Linux

NFS mount add in fstab _netdev instead of default | firewall-cmd --list-all