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/show-relaylog-events.html
End_log_pos The value of End_log_pos for this event in the source's binary log. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. This is the type of operation on the associated table for which the trigger activates. This is a TIMESTAMP(2) value (with a fractional part in ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
This is true whether the SQLSTATE value is specified directly in the SIGNAL statement or in a named condition referred to in the statement. If pval is 2, the same error is signaled, although the SQLSTATE value is specified using a named condition in ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
For the ENUM and SET data types, this does not occur; they are created as declared. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
This interface is not as efficient as using the binary protocol through a prepared statement API, but requires no programming because it is available directly at the SQL level: You can use it when no programming interface is available to you. This ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/refman/5.7/en/stop-group-replication.html
Warning Use this statement with extreme caution because it removes the server instance from the group, meaning it is no longer protected by Group Replication's consistency guarantee mechanisms. To be completely safe, ensure that your applications ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Terminology used in this document reflects the stored object hierarchy: Stored routines include stored procedures ...Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's character set and collation are the same as those of the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/sys-execute-prepared-stmt.html
Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined ...