Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/9.7/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. 19.1.2.5.1 Creating a Data Snapshot Using mysqldump To create a snapshot of ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/9.7/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/9.7/en/with.html
Consider these statements that create a small data set that shows, for each employee in a company, the employee name and ID number, and the ID of the employee's manager. CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-retrieve-schema-metadata.html
This output consists of a concise set of abridged CREATE TABLE statements for the tables that are most relevant to a natural-language statement, ranked in order of relevance. To view a copy of this license, visit ... Retrieves the most relevant ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. A non-identifying relationship: identified by a broken (dashed) line between tables Create or drag and drop the tables that you wish to connect. In ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-efmodel-ddl.html
This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. In the Generate Database Wizard dialog select an existing connection, or create a new connection to a server. You have seen how to create MySQL DDL code from an ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-efmodel-ddl.html
This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. In the Generate Database Wizard dialog select an existing connection, or create a new connection to a server. You have seen how to create MySQL DDL code from an ...
https://dev.mysql.com/doc/internals/en/event-flags.html
This flag should be set for any event that does not need to have the default database set to function correctly, such as CREATE DATABASE and DROP DATABASE. Event headers for v3 format and up contain event flags in the two flag bytes at position ...