MySQL Shell Blogs

Contents

    MySQL Shell 8.0.16: User Defined Reports

    ContentsBackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectIn my blog yesterday, I wrote about the new reporting framework in MySQL Shell. It is part of the 8.0.16 release. I also noted that it includes the possibility to

    Read More »

    MySQL Shell 8.0.16: Built-in Reports

    ContentsBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionReaders of my blog know that I like how MySQL Shell allows you to customize it and use it’s Python and JavaScript support to create custom libraries with tools that help with your

    Read More »

    MySQL 8: Drop Several Stored Events, Procedures, or Functions

    ContentsSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonMaybe the biggest new feature in MySQL 8 is the new transaction data dictionary that improves the consistency of schema objects among other things. To further

    Read More »

    Auto-Refreshing Reports in MySQL Shell

    ContentsBasic ExampleMySQL iotopMySQL Shell makes it easy to develop tools you can use for example to generate reports. In a previous blog, I showed how to use external modules in MySQL Shell. In this blog, I will take it one

    Read More »

    Awesome MySQL Shell Prompt

    ContentsSpecifying the Prompt TemplateAwesome Terminal FontsPowerline FontFantasque Awesome PowerlineA month ago, I wrote a blog on how you can configure the MySQL Shell prompt to suit your needs.  One thing I did not go into details with are the prompt

    Read More »

    MySQL Shell: Built-In Help

    ContentsGeneral HelpObject Based HelpIt can be hard to recall all the details of how a program and API work. The usual way to handle that is to look at the manual or a book. Another – and in my opinion

    Read More »

    MySQL Shell: Using External Python Modules

    ContentsUsing Standard ModulesExample ModuleImporting Modules Into MySQL ShellUsing the ModuleMySQL Shell is a great tool for working with MySQL. One of the features that make it stand out compared to the traditional mysql command-line client is the support for JavaScript

    Read More »

    Configuring the MySQL Shell Prompt

    ContentsThe Default PromptThe Prompt ConfigurationCreating Your Own ConfigurationWith the introduction of MySQL Shell 8.0, the second major version of the new command-line tool for MySQL, a new and rich featured prompt was introduced. Unlike the prompt of the traditional mysql

    Read More »