PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
Note This statement is replaced in later versions of MySQL by RESET BINARY LOGS AND GTIDS, and should be considered deprecated. See RESET BINARY LOGS AND GTIDS Statement, in the MySQL 8.4 Manual, for more information. RESET MASTER [TO ...A new ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...ST_AsGeoJSON(g [, max_dec_digits [, options]]) Generates a GeoJSON object from the ...
https://dev.mysql.com/doc/refman/8.0/en/windows-choosing-package.html
MySQL Installer downloads and applies updates to itself, and to each of the installed products. MySQL Installer This package has a file name similar to mysql-installer-community-8.0.45.0.msi or mysql-installer-commercial-8.0.45.0.msi, and utilizes ... For MySQL 8.0, there are multiple installation package formats to choose from when installing MySQL on ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
The EVENT privilege governs the creation, modification, and deletion of events. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
Note that the replica still has outdated data in a MEMORY table during the interval between the source's restart and its first use of the table. This causes the replica to be out of synchrony with the source and may lead to other failures or cause ... When a replication source server shuts down and restarts, its MEMORY tables become ...To avoid this interval when a direct query to the replica could return stale data, you can set the init_file system variable to ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
To update cached values at any time for a given table, use ANALYZE TABLE. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...If there are no cached ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. MySQL enables the creation of accounts ...Additional functionality includes the ability to grant privileges for administrative ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
https://dev.mysql.com/doc/refman/8.0/en/charset-server.html
By default, these are utf8mb4 and utf8mb4_0900_ai_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. MySQL Server has a server character set and a server collation. Initially, the ...If you don't specify a character set, that is the same as saying ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...To ...