PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Load operations (performed by invoking the flush_rewrite_rules() stored procedure) load the rule from the table into the Rewriter in-memory cache only if ...
https://dev.mysql.com/doc/refman/8.0/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. Stored procedures that take no arguments can be invoked without parentheses. (If you are calling the ...When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
An error occurs for attempts to apply them to user-defined variables, stored procedure or function parameters, or stored program local variables. An error occurs for attempts to assign DEFAULT to user-defined variables, stored procedure or function ...Parameter and Local Variable Assignment SET applies to parameters and local variables in the context of the stored object within which they are ...variable: { user_var_name | param_name | local_var_name | ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--routines, -R Command-Line Format --routines Include stored routines (procedures and functions) for the dumped databases in the output. These may be used when dumping stored programs to preserve their character encodings. For large-scale backup and ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
Note Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... You must use COMMIT to store your changes to disk or ROLLBACK to ignore the changes. (If ...SET ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
That is true for names of cursors, conditions, procedures, functions, savepoints, stored routine parameters, stored program local variables, and plugins. The following statement would not work because it refers to a table both as my_table and as ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if ...This means they have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in the ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. BLOB and TEXT columns only ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Examples: ANALYZE TABLE fails because it updates table statistics, which are stored in the data dictionary. ALTER TABLE tbl_name ENGINE=engine_name fails because it updates the storage engine designation, which is stored in the data dictionary. Use ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
When retrieved, values stored into an ENUM column are displayed using the lettercase that was used in the column definition. If you store a number into an ENUM column, the number is treated as the index into the possible values, and the value stored ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...