Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
This section provides information about the Table class, which models a database table in the NDB API. It is possible using the NDB API to create tables independently of the MySQL server. However, it is usually not advisable to do so, since tables ...This class extends the Object class, which in turn is an inner class of the NdbDictionary ...
https://dev.mysql.com/doc/internals/en/api-reference.html
...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-command-reference.html
...
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
Error number: 53; Symbol: EE_CONFIG_FILE_PERMISSION_ERROR; Message: %s should be readable/writable only by current user. Error number: 54; Symbol: EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE; Message: World-writable config file '%s' is ignored. This ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...| ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating ...One session cannot acquire locks for another session or release locks held by another ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...