PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Previously, an account-management statement (such as CREATE USER or DROP USER) that named multiple users could succeed for some users and fail for others. As of MySQL 8.0.27, MySQL supports multifactor authentication (MFA), which makes it possible ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
If expression evaluation causes truncation or provides incorrect input to a function, the CREATE TABLE statement terminates with an error and the DDL operation is rejected. Values of a generated column are computed from an expression included in the ...
https://dev.mysql.com/doc/refman/8.0/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/8.0/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. See also the notes about spatial indexes under Section 13.4.10, “Creating Spatial Indexes”. Use the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. For example, the following query performs better with an index on the Population field: mysql-js> ... Indexes ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. SELECT statement to make any changes in tables other than the table that is created by the statement. SELECT always performs an implicit ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/doc/refman/8.0/en/creating-rsa-files-using-openssl.html
See Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. To create the RSA private and public key-pair files, run these commands while logged into the system account used to run the MySQL server so that the files are owned ... This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password and caching_sha2_password ...
https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html
Note When using the MySQL Installer to install MySQL Server, it creates the my.ini at the default location, and the user executing MySQL Installer is granted full permissions to this new my.ini file. An option file can be created and modified with ... If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option ...