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/performance-schema-event-tables.html
For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. In addition, when events end, the Performance Schema can store them in history tables. The tables have names of the following forms, ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. For ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
This may be useful for Web applications that obtain year, month, and day in three different fields and store exactly what the user inserted, without date validation. It is always permissible to have spaces after a loadable function or stored ... The ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. For example: SET time_zone = 'MET'; Unique UTC values stored in the ...
https://dev.mysql.com/doc/refman/8.0/en/local-variable-scope.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ... The scope of a local variable is the BEGIN ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
Where are triggers stored? Triggers are stored in the mysql.triggers system table, which is part of the data dictionary. Where can I find the documentation for MySQL 8.0 triggers? A.5.2. Is there a way to view all triggers in a given database? A.5.7. Can a table have multiple triggers with the same trigger event and action time? ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. INTO form of SELECT enables a query result to be ...Column and line terminators can be specified to produce a specific output ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Nor are values in those data types stored in UTC; the time zone applies for them only when converting from ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. Even with additional write costs, secondary indexes on virtual columns may be preferable to ...A ...