MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 761 to 770 of 775 total results

6.4.1.11 Socket Peer-Credential Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html

If the names do not match, the plugin checks whether the socket user name matches the name specified in the authentication_string column of the mysql.user system table row. The authentication_string value can be specified using an IDENTIFIED ...AS ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...

11.4 Spatial Data Types

https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html

The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications ...

23.8 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html

Thus, stored functions and triggers cannot use dynamic SQL (where you construct statements as strings and then execute them). Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions.

23.1 Defining Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html

Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...

5.1.8.3 Structured System Variables

https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html

The variable is not interpreted as a compound name, but as a simple string for a LIKE pattern-matching operation: mysql> SHOW GLOBAL VARIABLES LIKE 'hot_cache.key_buffer_size'; This is the exception to being able to use structured variable names ...

26.4.5.3 The format_bytes() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-format-bytes.html

Given a byte count, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is bytes, KiB (kibibytes), MiB (mebibytes), GiB (gibibytes), TiB ...

26.4.5.4 The format_path() Function

https://dev.mysql.com/doc/refman/5.7/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 slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...

26.4.5.6 The format_time() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-format-time.html

Given a Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is ps (picoseconds), ns ...

26.4.3.21 The metrics View

https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html

The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...

26.4.5.18 The quote_identifier() Function

https://dev.mysql.com/doc/refman/5.7/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 ...

Displaying 761 to 770 of 775 total results