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/grant-tables.html
The procs_priv table applies to stored routines (stored procedures and functions). To update the tables to the expected structure, perform the MySQL upgrade procedure. The procs_priv scope columns indicate the stored routine to which each row ...
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/upgrading-from-previous-series.html
This includes replication of CREATE statements for stored programs (stored procedures and functions, triggers, and events) that are executed while the current sql_mode value includes any of the removed modes. In previous MySQL series, dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
Valid target designators for storing item information can be stored procedure or function parameters, stored program local variables declared with DECLARE, or user-defined variables. Valid condition_number designators can be stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
A key_part specification can end with ASC or DESC to specify whether index values are stored in ascending or descending order. Use of functional key parts enables indexing of values not stored directly in the table. Subqueries, parameters, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
caching: Use both InnoDB and the memcached engine as data stores. config_options Table The config_options table stores memcached-related settings that can be changed at runtime using SQL. For example, if you define col1, col2 as value columns, and ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The rows of an InnoDB table are stored in a clustered index organized based on the primary key, forming what some database systems call an “index-organized table”. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. When CHAR values are stored, they ...They also differ in maximum length and in whether trailing spaces are ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. MySQL stores VARCHAR values as a 1-byte or 2-byte length prefix plus data.
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 ...