#Mycli opinioni install
We can install mycli on any Linux distro thanks to python, for this we simply have to have pip installed and execute the following command: $ sudo pip install -U mycliĭebian and ubuntu users can install the tool directly from the official repositories by running $ sudo apt-get install mycli Detailed documentation when running the help of the tool $ mycli -help.The data output is organized and pleasant, it is shown in columns with tabular separations.It has an extensive log system, in case we want to save the history of the executed commands.Powerful and simple configuration file, which is automatically generated in the directory ~/.myclirc.It allows to store the most used queries, for this it is enough to save a query using \fs alias query and use the following command \f alias when you want to run it again.Support for queries that include more than one line.SELECT * FROM users WHERE it will only show the column names.SELECT * FROM it will only show the names of the tables.Smart auto-completion (which is enabled by default), which will only offer context-related hints.Excellent syntax highlighting thanks to Pygments.Auto-complete as SQL keywords are typed, as well as database tables, views, and columns.Completely open source, developed in python and with excellent documentation.It has a fairly short installation and learning line, which added to its excellent characteristics make it a very interesting alternative to tools dedicated to database management, especially due to its low consumption of resources and its accelerated response time.Ī detailed use of the tool can be seen in the following gif released by the tool's developers: The tool has an advanced autocompletion system for the aforementioned database languages, in the same way, it highlights the syntax in a standard way, which helps us to manage our databases in a comfortable way from the terminal.
Mycli is an open source tool, developed in Python, which allows us to manage and execute MySQL, MariaDB, and Percona commands in a fast, automated and efficient way.
0 kommentar(er)
