MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 31 to 40 of 1832 total results

https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

The default_table_encryption variable defines an encryption default for newly created schemas and general tablespace. By default, a table inherits the encryption of the schema or general tablespace it is created in. The privilege check occurs when ...In previous MySQL releases, dictionary data was stored in metadata files and nontransactional ...

19.5.1.6 Replication of CREATE ... IF NOT EXISTS Statements

https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-if-not-exists.html

Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 19.5.1.7, “Replication of CREATE TABLE ... IF NOT ...

15.1.12 CREATE DATABASE Statement

https://dev.mysql.com/doc/refman/8.0/en/create-database.html

CREATE DATABASE is not permitted within a session that has an active LOCK TABLES statement. The ENCRYPTION option, introduced in MySQL 8.0.16, defines the default database encryption, which is inherited by tables created in the database. Because ...

15.1.16 CREATE LOGFILE GROUP Statement

https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html

You can verify that the UNDO files were created and obtain information about them by querying the Information Schema FILES table. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] ...

15.7.7.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/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_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...

15.7.7.13 SHOW CREATE VIEW Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html

SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to ...

5.3.1 Creating and Selecting a Database

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 ...

8.3.3.2 Creating SSL Certificates and Keys Using openssl

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

See Section 8.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 ...

15.7.7.6 SHOW CREATE DATABASE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-database.html

row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ SHOW CREATE DATABASE quotes table and column names ...If ...

15.7.7.7 SHOW CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html

SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. For example (using the same event e_daily defined and then altered in Section 15.7.7.18, “SHOW EVENTS Statement”): mysql> SHOW ...

Displaying 31 to 40 of 1832 total results