PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not include built-in (native) functions or loadable functions. DATA_TYPE If the routine is a stored function, the return ...The column named “mysql.proc Name” indicates the mysql.proc table column that corresponds to the INFORMATION_SCHEMA ROUTINES table column, if ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service routines. As a C language interface, callable as a plugin service from server ... MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
mysql> SET sql_mode = ''; mysql> SELECT NOT 1 BETWEEN -5 AND 5; -> 0 mysql> SET sql_mode = 'HIGH_NOT_PRECEDENCE'; mysql> SELECT NOT 1 BETWEEN -5 AND 5; -> 1 IGNORE_SPACE Permit spaces between a function name and the ( character. This causes built-in ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
Columns retrieved by the SELECT statement can be simple references to table columns, or expressions that use functions, constant values, operators, and so forth. Within a view definition, the CURRENT_USER function returns the view's DEFINER value by ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
An API provides a stable set of names and types for functions, procedures, parameters, and return values. client libraries Files containing collections of functions for working with databases. client-side prepared statement A type of prepared ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
The plugin library file contains the keyring_aws plugin and two loadable functions, keyring_aws_rotate_cmk() and keyring_aws_rotate_keys(). Start the MySQL server and install the functions associated with the keyring_aws plugin. This is a one-time ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--allow-suspicious-udfs Command-Line Format --allow-suspicious-udfs[={OFF|ON}] Type Boolean Default Value OFF This option controls whether loadable functions that have only an xxx symbol for the main function can be loaded. By default, the option is ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
To retrieve an AUTO_INCREMENT value after inserting a row, use the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. This clause contains the function that is used to determine the partition; the function returns an integer ...| ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of SQL functions which are permitted in partitioning expressions, see Section 22.6.3, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
This includes removal of the mysql_old_password authentication plugin and the OLD_PASSWORD() function. The client can do this by using the PASSWORD() function to generate a password hash, or by using a password-generating statement (CREATE USER, ...