Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-added.html
An alternative to generating and running the ALTER ONLINE TABLE ... REORGANIZE PARTITION steps is to make use of the logical backup of the NDB tables' metadata, which is part of the cluster backup created by MySQL Cluster Manager. Restore the ... A ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
auth_string: The value of the authentication_string column of the row in the mysql.user system table for the matching account name (that is, the row that matches the client user name and host name and that the server uses to determine how to ...
https://dev.mysql.com/doc/workbench/en/wb-foreign-key-relationships.html
MySQL Workbench enables you to add a foreign key from within the table editor or from within an EER diagram by using the relationship tools on the vertical toolbar. To add a foreign key using the table editor, see Section 8.1.10.4, “Foreign Keys ... Foreign key constraints are supported for the InnoDB storage engine ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
Workbench model data, such as diagrams, schemas, and tables, is stored in a hierarchy of objects that can be accessed by any plugin. Main Nodes in the Application Object Tree Table C.1 The main nodes in the Application Object Tree Node Description ... The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
The Contents subtab defines the schemas and tables to back up, and whether the job is a full or partial backup: Full backup: All schemas and tables are backed up (see the figure that follows). Figure 6.28 Workbench: MySQL Enterprise Backup ... This ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
It has a section for each object type present in the schema that you can import (tables, views, routines, and so forth). The following figure shows an example of the table object section with the filter open. Figure 9.53 Select Objects The options ... To reverse-engineer a live database, click Database and then Reverse Engineer from the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-serverprep.html
For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); After creating ... The first step is using MySQL with BLOB data is to configure the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-bulk-loader.html
First an empty table needs to be created, in this case in the test database. CREATE TABLE Career ( Name VARCHAR(100) NOT NULL, Age INTEGER, Profession VARCHAR(200) ); A simple tab-delimited data file is also created (it could use any other field ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
If CommandType is set to TableDirect, all rows and columns of the named table are returned when you call one of the execute methods. In effect, this command performs a SELECT * on the table specified. The CommandText property is set to the name of ... The MySqlCommand class represents a SQL statement to execute against a MySQL ...