Mysql client
From wikinotes
Commandline client for mysql.
Alternatives
mycli mysql client based on prompt toolkit
Usage
mysql -u USER \ -h ADDR \ -D DATABASE# If you have too many rows for your console, you can end query in # \G and the format will be altered for readability. SELECT * FROM sometable\G # also, you can use less as your pager pager less -SFX
Configuration
vi mode
mysql uses gnu readline. To enable vi mode simply:
linux, macos<=10.4
# ~/.inputrc set editing-mode vi set keymap vimacos>=10.5
# ~/.editrc bind -v