MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 111 to 120 of 499 total results

16.2.2.2 Compatibility with Previous Replication Statements

https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html

Warning Use RESET SLAVE with caution as this statement deletes all existing channels, purges their relay log files, and recreates only the default channel. In this case, error 1964 Multiple channels exist on the slave. When a replica has multiple ...

13.1.11 CREATE DATABASE Statement

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

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... An error occurs if the database exists and you did not specify IF NOT EXISTS. create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name } CREATE ...

13.1.12 CREATE EVENT Statement

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

CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... IF NOT EXISTS ...

13.1.18.4 CREATE TABLE ... SELECT Statement

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

With IGNORE, rows that duplicate an existing row on a unique key value are discarded. SELECT, if IF NOT EXISTS is given and the target table exists, nothing is inserted into the destination table, and the statement is not logged. You can create one ...

2.9.4 Securing the Initial MySQL Account

https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html

Choose whichever of the following procedures applies: If the root account exists with an initial random password that has been expired, connect to the server as root using that password, then choose a new password. Because the password exists, you ... The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL ...

19.2 Setting Up MySQL as a Document Store

https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html

Important The mysql.session user must exist before you can load X Plugin. To use MySQL 5.7 as a document store, the X Plugin needs to be installed. Then you can use X Protocol to communicate with the server. Without the X Plugin running, X Protocol ...

13.1.23 DROP EVENT Statement

https://dev.mysql.com/doc/refman/5.7/en/drop-event.html

DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. If the event does not exist, the error ERROR 1517 (HY000): Unknown event 'event_name' results. You can override this and cause the statement to generate a warning ...

13.1.27 DROP PROCEDURE and DROP FUNCTION Statements

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

DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or function). See Section 23.2.2, “Stored Routines and MySQL Privileges”.) The IF EXISTS clause is a MySQL extension. It ...

23.4.6 The Event Scheduler and MySQL Privileges

https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html

This is because different events of the same name can exist in different schemas. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs ...

8.8.3 Extended EXPLAIN Output Format

https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html

<exists>(query fragment) The subquery predicate is converted to an EXISTS predicate and the subquery is transformed so that it can be used together with the EXISTS predicate. For SELECT statements, the EXPLAIN statement produces extra ...

Displaying 111 to 120 of 499 total results