Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE TestTable (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100)); The main method of the MySqlScript class is the Execute method.
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
After it has been created, there are three main methods of interest that you can call: ExecuteReader to query the database. Results are usually returned in a MySqlDataReader object, created by ExecuteReader. After the MySqlCommand object is created, ... When a connection has been established with the MySQL database, the next step enables you to perform database ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
Table 20-1 Table 20-2 Table 20-3 Note: The OCI user account that registered for the MySQL HeatWave on AWS service is added to the OracleMySQLHeatwaveServiceAccountAdmin group when the service is provisioned. Any other users must be added to at least ... Groups and Permissions 20.1 Groups and Permissions MySQL HeatWave on AWS has three predefined ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category.
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered index. There are six columns, three of which are hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and ... You ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
The following instructions describe how to create the certificate and key files using OpenSSL. (Optional) To check key file content and validity, use the following commands: openssl rsa -in company.key -check openssl rsa -in vault.key -check Create ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-network-config-ibr-privatelink.html
Configuring the Network Infrastructure for an Egress PrivateLink 6.2.1 Configuring the Network Infrastructure for an Egress PrivateLink Before creating an Egress PrivateLink, configure the network infrastructure in your AWS account. Create and ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Before using MySQL Enterprise Data Masking and De-Identification, install it ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
These functions support the use of a key derivation function (KDF) to create a cryptographically strong secret key from the information passed in key_str. The derived key is used to encrypt and decrypt the data, and it remains in the MySQL Server ...