Search Results
https://dev.mysql.com/doc/workbench/en/wb-creating-eer-diagram.html
To create an EER diagram for the sakila database, first add an EER diagram by double-clicking the Add Diagram icon in the EER Diagrams panel to create and open a new EER Diagram editor. Find the sakila schema and expand the view of its objects by ...To add a table to the canvas, select the Catalog tab in the middle panel on the right side of the application to display any schemas that appear in the MySQL Model ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
mysql> SELECT SUBSTRING('Quadratically',5); -> 'ratically' mysql> SELECT SUBSTRING('foobarbar' FROM 4); -> 'barbar' mysql> SELECT SUBSTRING('Quadratically',5,6); -> 'ratica' mysql> SELECT SUBSTRING('Sakila', -3); -> 'ila' mysql> SELECT ...For ...
https://dev.mysql.com/doc/connectors/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...
https://dev.mysql.com/doc/refman/8.4/en/history.html
The name of the MySQL Dolphin (our logo) is “Sakila,” which was chosen from a huge list of names suggested by users in our “Name the Dolphin” contest. According to Ambrose, the feminine name Sakila has its roots in SiSwati, the local ... We ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/connector-j/en/connector-j-opentelemetry.html
This simple demonstration contains a class OTelDemo, which creates a connection to the Sakila database and executes an SQL SELECT statement that returns five rows from the table film. OpenTelemetry is a set of APIs, libraries, agents, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
mysql> CALL sys.heatwave_load(JSON_ARRAY("tpch","airportdb","employees","sakila"),NULL); Load multiple schemas with the not_disable_unsupported_columns policy, which causes tables with unsupported columns to be excluded from the load operation.
https://dev.mysql.com/doc/connector-python/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/refman/8.4/en/innodb-moving-data-files-offline.html
For example, if the actor table belongs to the sakila schema, then the actor.ibd data file can only be moved to a directory named sakila. The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports ...