PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, users would not be able to name columns and tables using their own languages. The metadata requirements mean that the ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Input Preprocessing Each instance of col_name_or_user_var in LOAD DATA syntax is either a column name or a user variable. With user variables, the SET clause enables you to perform preprocessing transformations on their values before assigning the ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
A “login path” is an option group that permits only certain options: host, user, password, port and socket. If multiple instances of a given option are found, the last instance takes precedence, with one exception: For mysqld, the first instance ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. The maximum possible number of user-defined partitions for a table using the NDB storage engine is determined according to the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
The session user must have privileges sufficient to set restricted session variables. If set to 0 (the default), users are not permitted to create or alter stored functions unless they have the SUPER privilege in addition to the CREATE ROUTINE or ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
It is possible for a procedure to follow different execution paths on source and replica servers, so a user can write a routine containing a dangerous statement that executes only on the replica where it is processed by a thread that has full ...
https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html
For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...