PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
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 ...
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 ...
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 [=] ...
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 ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). Creating a foreign key constraint requires the REFERENCES privilege on the parent table. Such an index is created on the referencing ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...If ...
https://dev.mysql.com/doc/refman/8.0/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_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/create-role.html
CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are named collections of privileges. To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. When the read_only system ...If ...