Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. Explicit selection of ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/workbench/en/wb-design-table-templates.html
Define table templates with commonly used columns and settings to create new tables from either a live connection or while creating an EER model. From the SQL editor, select Create Table Like from the Tables context menu, as shown in the next ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-live-server.html
The first step of the process is to connect to a MySQL server to create the new database schema. The next page enables you to set options for the database to be created (see the following figure). These options are as described in Section 9.4.1.1.1, ... Use forward engineering to export your schema design to a MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
Initially, this loads an "Easy Setup" page that is enough for most users. To create a custom group, right-click on a variable and choose either Add to Custom Category (to create a new category), or an existing custom category. This also has a ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support for foreign keys, the driver would transparently support them as well. To enable this functionality, create a Statement instance in the ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
The second INSERT depends on the value of the newly created primary key of the first. Note The following example uses tables created in the example Section 6.5.2, “Creating Tables Using Connector/Python”. We then create a new cursor, by default ... Inserting or updating data is also done using the handler structure known as a ...
https://dev.mysql.com/doc/connectors/en/connector-python-opentelemetry.html
Introduction to OpenTelemetry OpenTelemetry is an observability framework and toolkit designed to create and manage telemetry data such as traces, metrics, and logs. A query span is created for each query request sent to the server. Query spans for ... MySQL Server added OpenTelemetry support in MySQL Enterprise Edition version 8.1.0, which is a commercial ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
The second INSERT depends on the value of the newly created primary key of the first. Note The following example uses tables created in the example Section 5.2, “Creating Tables Using Connector/Python”. We then create a new cursor, by default a ... Inserting or updating data is also done using the handler structure known as a ...