Use a Command for MySQL with Autocomplete
Practical and with syntax highlighting!
Who never forgot reserved names from MySQL/MariaDB or typed them incorrectly? To significantly lessen these problems, there is the
mycli is a terminal client for MySQL with autocomplete and syntax highlighting.
The fastest and most practical way to install MyCLI is using pip, remember to have it installed on your system first. To do this, just install it as follows:
This will install only for your user, and you will need to have the path
Other ways and for other operating systems it would be:
After properly installed, you can now log into your MySQL server, with the following command similar to
If you type the SQL commands in uppercase or lowercase it will autocomplete anyway. It also doesn’t need a semicolon (
;) to end commands
For more information use the
--help argument/parameter and refer to the GitHub repository .