MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 41 to 50 of 1234 total results

https://dev.mysql.com/doc/refman/5.7/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...

13.1.18.4 CREATE TABLE ... SELECT Statement

https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html

You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...

14.6.1.2 Creating Tables Externally

https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html

There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. InnoDB supports the following methods for creating tables externally: Using the DATA DIRECTORY Clause Using CREATE TABLE ...

6.3.3.2 Creating SSL Certificates and Keys Using openssl

https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html

See Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. There is no extendedKeyUsage extension in SSL certificates created using the openssl command following the instructions in this topic. If you use your own client ...

13.1.17 CREATE SERVER Statement

https://dev.mysql.com/doc/refman/5.7/en/create-server.html

CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...

3.3.1 Creating and Selecting a Database

https://dev.mysql.com/doc/refman/5.7/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 ...

6.3.3.1 Creating SSL and RSA Certificates and Keys using MySQL

https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html

Files created automatically by the server are owned by the account that runs the server. Files created using mysql_ssl_rsa_setup are owned by the user who invoked that program. If you use your own client certificate created in another way, ensure ...

13.7.5.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html

row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Create Procedure: CREATE ... SHOW CREATE ...

13.1.18.7 CREATE TABLE and Generated Columns

https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html

A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...Values of ...

13.7.5.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html

row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE ... SHOW CREATE ...

Displaying 41 to 50 of 1234 total results