MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 41 to 47 of 47 total results

« Previous
1
2
3
4
5
Next »

25.5.23 ndb_restore — Restore an NDB Cluster Backup

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html

--fields-optionally-enclosed-by Command-Line Format --fields-optionally-enclosed-by Type String Default Value The string passed to this option is used to enclose column values containing character data (such as CHAR, VARCHAR, BINARY, TEXT, or ENUM).

28.3.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-table.html

The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema ...

6.6.4.5 Obtaining Table Information with myisamchk

https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html

To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...

7.6.9.1 The Locking Service

https://dev.mysql.com/doc/refman/8.0/en/locking-service.html

Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...

7.1.9.2 Dynamic System Variables

https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html

Variables that are marked as “enumeration” normally should be set to one of the available values for the variable, but can also be set to the number that corresponds to the desired enumeration value. For enumerated system variables, the first ...

17.9.2 InnoDB Page Compression

https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html

InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...