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/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
and db_name.event_name notation, as shown here: ALTER EVENT olddb.myevent RENAME TO newdb.myevent; To execute the previous statement, the user executing it must have the EVENT privilege on both the olddb and newdb databases. ALTER [DEFINER = user] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
If you rotate the binary log master key because you suspect that the current or any of the previous binary log master keys might have been compromised, issue the statement on every applicable source and replica server, which enables you to verify ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
For example, you cannot have a tablespace and an undo log file with the same name, or an undo log file and a data file with the same name. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
In addition, any data file to be dropped must previously have been added to the tablespace with CREATE TABLESPACE or ALTER TABLESPACE. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
For example, if an UPDATE HISTOGRAM statement names multiple columns, but some of them do not exist or have an unsupported data type, histograms are generated for the other columns, and messages are produced for the invalid columns. ANALYZE ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
Use of an explicit MATCH clause does not have the specified effect, and it causes ON DELETE and ON UPDATE clauses to be ignored. For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-update.html
The result is that col1 and col2 have the same value. If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current ...