The MySQL X DevAPI is the new API that provides a uniform API
across the supported programming languages. It has from the
beginning supported that you can specify a default schema, when
you connect. Originally it was not used for SQL statements.
Starting with MySQL 8.0.14 the feature has been extended, so SQL
statements take the default schema into consideration as well.
This blog will explore how this works using MySQL
Connector/Python. If you use a different programming language,
the change will work in a similar way.
In order to explore the feature, a sample program is needed. A
simple program that prints the MySQL Connector/Python version,
queries the [Read more]
the default schema, and either …