MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 781 to 790 of 797 total results

https://dev.mysql.com/doc/refman/5.7/en/set-character-set.html

Attempting to use them with SET CHARACTER SET produces an error. SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets ...

13.7.5.4 SHOW COLLATION Statement

https://dev.mysql.com/doc/refman/5.7/en/show-collation.html

SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...

13.7.5 SHOW Statements

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

6.4.1.11 Socket Peer-Credential Pluggable Authentication

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

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

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 ...

5.1.8.3 Structured System Variables

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

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 ...

Displaying 781 to 790 of 797 total results