PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
This function assumes that the file name lies within the schema directory. For this reason, it does not work with partitions or tables defined using their own DATA_DIRECTORY table option. This function is useful when extracting file I/O information ... Given a file path name, returns the path component that represents the schema ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. This attempt might fail because the ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a key lookup. This is common for tables with fewer than 10 rows and a short row length. In this case, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
This directory should be in a disk-based file system (not a memory-based file system) so that the temporary files used to replicate LOAD DATA can survive machine restarts. On platforms that support it (such as Unix), this is done by unlinking the ...