PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support loadable functions. If binary logging is enabled, CREATE FUNCTION might ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-files.html
For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an InnoDB table is created in the system tablespace, table data and ...The ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Within a string, certain sequences have special meaning unless the NO_BACKSLASH_ESCAPES SQL mode is enabled. Each of these ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The result is a sequence of files that are subject to access using the log-reading functions: audit_log_read() reads events from the audit log or closes the reading process. To use the functions to read the audit log, follow these principles: Call ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. For information about the physical representation of a table, see ...| ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
The server creates relay log files in sequence by adding a numeric suffix to the base name. --replicate-do-db=db_name Command-Line Format --replicate-do-db=name Type String Creates a replication filter using the name of a database. Such filters can ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. (CREATE FUNCTION is also used to created stored functions; ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system schema. When the read_only system variable is enabled, CREATE ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ...