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/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
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/mysqldump.html
To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those statements. Note A dump made using PowerShell on Windows with output ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Beginning with MySQL 8.0.34, this function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). NDB Cluster stores foreign names using the same lettercase with which they are created. Creating a foreign key constraint requires the ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. This setting has no effect on tables created using any other storage engine than InnoDB. row ...When ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. Another option for creating accounts is to use the GUI tool MySQL Workbench. This section discusses the following ...
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-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed.