Shulou(Shulou.com)06/01 Report--

The tab key cannot be used for automatic completion by default in mysql. The automatic settings are as follows:

The complements here are table names, column names, and database names. Not commands, variables, etc., in the database.

On the mysql command line, use\ # to temporarily enable tab completion.

Add auto-rehash this field to the [mysql] section of mysql's configuration file my.cnf to achieve completion

Add the-- auto-rehash parameter to the mysql command

You can use a mycli tool.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.