Search Results
https://dev.mysql.com/doc/refman/8.4/en/compatibility.html
The SQL standard has been evolving since 1986 and several versions exist. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how ...
https://dev.mysql.com/doc/refman/8.4/en/compilation-problems.html
When CMake starts, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use ...
https://dev.mysql.com/doc/refman/8.4/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
If the master.info file exists, it contains lines for those values as well. Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the connection. By default, connections are ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
To require use of encrypted connections by a MySQL account, use CREATE USER to create the account with a REQUIRE SSL clause, or use ALTER USER for an existing account to add a REQUIRE SSL clause. This section describes options supported by most ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/8.4/en/create-resource-group.html
CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
MySQL system tables still exist in MySQL 8.4 and can be viewed by issuing a SHOW TABLES statement on the mysql system database. Data dictionary tables are protected and may only be accessed in debug builds of MySQL. However, MySQL supports access ...