Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. This section does not provide in-depth information on creating stored procedures. For example, to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. This section does not provide in-depth information on creating stored procedures. For example, to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
The following is some additional information on partial restores using TTS backups To backup and restore backups created using TTS, extra privileges are required of the user through which mysqlbackup connects to the server; see Section 4.1.2, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Compressed tables can be created in file-per-table tablespaces or in general tablespaces.
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. This setting has no effect on tables created using any other storage engine than InnoDB. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
The program performs such functions as creating, signing, and retiring keys and certificates, and normally works as follows: ndb_sign_keys connects to ndb_mgmd and fetches the cluster' configuration. For each cluster node that is configured to run ... Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...If omitted, MySQL generates a name from the table name, a literal _chk_, and an ordinal number (1, 2, 3, ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-example.html
The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database. The following example shows the process of creating a database from existing code. Initialize a valid .NET ...MySQL Connector/NET is compatible with multiple versions of Entity Framework ...