PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.2Mb
Man Pages (TGZ)
- 295.4Kb
Man Pages (Zip)
- 400.6Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/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/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] ...
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/create-tablespace.html
Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example Considerations for InnoDB CREATE TABLESPACE syntax is used to create general tablespaces or undo tablespaces. The UNDO keyword, introduced in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...
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/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 ...