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/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. Password hash values displayed in the IDENTIFIED WITH clause of output from SHOW CREATE USER may contain unprintable characters that have adverse ...
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/option-files.html
Many option files are plain text files, created using any text editor. It is created by the server upon execution of SET PERSIST or SET PERSIST_ONLY statements. If an option file you want to use does not exist, create it using the appropriate ...
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 ...