Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: 200 clustered_index_size: 1 sum_of_other_index_sizes: 1 ...mysql> SELECT * FROM innodb_index_stats \G *************************** 1. row ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
install-sample-database N/A install-example-database list All, Sakila, World, None none configure, reconfigure N/A Installs the specified sample databases. uninstall-sample-database N/A uninstall-example-database list All, Sakila, World, None none ... MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
In other words, ExtractValue('<a><b>Sakila</b></a>', '/a/b') and ExtractValue('<a><b>Sakila</b></a>', '/a/b/text()') produce the same result. Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html
The following figures show an example of an export sequence of the sakila.actor table to a CSV file. The following figures show an example of an import sequence of the sakila.actor table from a CSV file. This wizard supports import and export ...
https://dev.mysql.com/doc/workbench/en/wb-tutorials.html
Importing an SQL data definition script is probably the quickest way to familiarize yourself with MySQL Workbench—this tutorial makes use of the sakila database and emphasizes the use of MySQL Workbench as a documentation tool. Examples taken from ... This chapter contains three short tutorials intended to familiarize you with the basics of MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-php-pdo.html
The following connection example defines "sakila" as the default database in the generated code. $host="localhost"; $port=3306; $socket=""; $user="root"; $password=""; $dbname="sakila"; try { $dbh = new ... MySQL Workbench includes a plugin that ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
Figure 9.1 Data Models on the Home Screen The sakila database sample includes a model file (sakila.mwb) in the product package. After you set up the database using the instructions provided on the download page, MySQL Workbench adds the sakila_full ... MySQL Workbench represents each active data model as an icon in the models view of the home screen ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-connecting.html
The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection object. The following example shows how to connect to the MySQL server: import mysql.connector cnx = mysql.connector.connect(user='scott', ...
https://dev.mysql.com/doc/workbench/en/wb-generating-php.html
This example will use the sakila database, with the query being: SET @last_update = '2006-02-14'; SELECT actor_id, first_name, last_name, last_update FROM actor WHERE last_update > @last_update; While in the SQL editor, choose Tools, Utilities, Copy ... MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by using the Tools, Utilities, Copy as PHP Code menu ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-backup-recovery.html
For example, the following figure shows a set of sakila database tables, whether each table is in the backup and in the MySQL instance, and the action to be performed by the wizard. The backup-recovery wizard is used to restore MySQL Enterprise ...