PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_general_ci; Tables created in the database ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Create the secret by passing the key length to create_dh_parameters(), then pass the secret as the “key length” to create_asymmetric_priv_key(). Limit CPU usage by key-generation operations The create_asymmetric_priv_key() and ... To use MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_install_db This program initializes the MySQL data directory, creates the mysql database and initializes its grant tables with default privileges, and sets up the InnoDB system tablespace. mysql_ssl_rsa_setup This program creates the SSL ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table, innodb_file_format, and innodb_page_size variables, and the ROW_FORMAT and KEY_BLOCK_SIZE clauses of the ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-starting.html
You need an account name and password to establish a session using MySQL Shell. On the same system where the server instance is running, open a terminal window (command prompt on Windows) and start MySQL Shell with the following command: mysqlsh ...