PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. See Section 27.2.2, “Stored Routines ... DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-add.html
The value of the _id field must be unique among all documents in the same collection. To work with the collections in a schema, use the db global object to access the current schema. In this example we are using the world_x schema imported ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-add.html
The value of the _id field must be unique among all documents in the same collection. To work with the collections in a schema, use the db global object to access the current schema. In this example we are using the world_x schema imported ...
https://dev.mysql.com/doc/refman/8.0/en/restart.html
For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables that can be set only at server startup, but the server must still be restarted for those changes to take effect. One use for RESTART is when it is ...Because status variables are initialized for each server startup and do not persist across restarts, Com_restart normally has a value of zero, but can be nonzero if RESTART statements were executed but ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
Note The following examples use DEFAULT 0, a default that can produce warnings or errors depending on whether strict SQL mode or the NO_ZERO_DATE SQL mode is enabled. If a TIMESTAMP or DATETIME column definition includes an explicit fractional ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. The grammar shown here is based on that given in the sql/sql_yacc.yy file of ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
INFORMATION_SCHEMA is an information database, so its name is included in the output from SHOW DATABASES. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure ...Several SHOW statements accept a WHERE clause that provides more flexibility in specifying which rows to ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
Loadable functions, as the name implies, must be loaded into the server before they can be used. For example: CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; The file base name depends on your platform. For this reason, CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-remote-connections.html
To accept IPv6 connections from clients outside the local network, the server host must have a public address. For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as ... The following procedure shows how to configure MySQL to permit IPv6 connections by remote ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-options.html
Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 29.4, ...Options ...