Use tab to automatically complete mysql commands and tab to complete mysql

Use tab to automatically complete mysql commands and tab to complete mysql
1. Use mysql -- help to view mysql Command Parameters
Note:
-- Auto-rehash Enable automatic rehashing. One doesn' t need to use
'Rehash' to get table and field completion, but startup
And reconnecting may take a longer time. Disable
-- Disable-auto-rehash.
(Defaults to on; use -- skip-auto-rehash to disable .)
2. Temporary Use

# Mysql-u root-p -- auto-rehash

There will be a prompt, you can ignore it

Switch to database

3. permanent use

Edit/etc/my. cnf
Comment out no-auto-rehash in [mysql]
Add auto-rehash
Log out of mysql Command Line

Log on to the database and call the tab key for testing.

Note: auto-completion is a client command, which must be switched to the database for use.