PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...When a user executes a successful ALTER EVENT statement, that user becomes the definer for the affected ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
Once a data file has been created, its size cannot be changed; however, you can add more data files to an NDB tablespace using additional ALTER TABLESPACE ... ADD DATAFILE is used with ENGINE = NDB, a data file is created on each Cluster data node, ...It can be used to add a new data file to, or to drop a data file from an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. The setup for the source is: CREATE TABLE t1 (public_col_1, ..., public_col_N, secret_col_1, ..., secret_col_M) ENGINE=MyISAM; The setup for ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET ... Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column ...
https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. If you examine the test.CSV file in the database directory created by executing the preceding statements, ... The CSV storage engine stores data in text files using comma-separated values ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Before using MySQL Enterprise Data Masking and De-Identification, install it ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
As of MySQL 8.0.30, these functions support the use of a key derivation function (KDF) to create a cryptographically strong secret key from the information passed in key_str. When you use a KDF, the function creates a cryptographically strong secret ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
MYSQL_TEST_LOGIN_FILE is the path name of the login path file (the file created by mysql_config_editor). The UMASK and UMASK_DIR variables, despite their names, are used as modes, not masks: If UMASK is set, mysqld uses ($UMASK | 0600) as the mode ... This section lists environment variables that are used directly or indirectly by ...