PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump includes the contents of the gtid_executed set in the dump to transfer these to the new machine. In cases where you need to transfer databases ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
Note that the variable values written in the error log may not always be 100% correct. Each MySQL version is tested on many platforms before it is released. This does not mean that there are no bugs in MySQL, but if there are bugs, they should be ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
Note All NDB Cluster Disk Data objects share the same namespace. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
Note Specifying a parameter as IN, OUT, or INOUT is valid only for a PROCEDURE. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
Note The OWNER option is currently not applied, and has no effect on the ownership or operation of the server connection that is created. CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
For detailed explanations of how each projection works, including formulas, see EPSG Guidance Note 7-2. srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Note Constraint expression evaluation uses the SQL mode in effect at evaluation time. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
Note Expression evaluation uses the SQL mode in effect at evaluation time. Values of a generated column are computed from an expression included in the column definition. Generated column definitions have this syntax: col_name data_type [GENERATED ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. This means that two different sessions can use the same temporary table ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...