Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely related. There might be several instances of a given type of structured ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-bytes.html
Note format_bytes() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_BYTES() function instead. See Section 14.21, “Performance Schema Functions” Given a byte ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-time.html
Note format_time() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.21, “Performance Schema Functions” Given a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...