PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/firewall-usage.html
Grant the EXECUTE privilege for the firewall stored procedures in the mysql system database. These may invoke administrative functions, so stored procedure access also requires the privileges indicated earlier that are needed for those functions.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). If the routine is a stored procedure, this value is empty. If the routine is a stored procedure, this value is NULL. If the routine is a stored ...DATA_TYPE If the routine is a stored function, the return value data ...The ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Historically, used by some Connector/J, Connector/ODBC, and Connector/PHP developers to work around issues with server-side stored procedures. stored program A stored routine (procedure or function), trigger, or Event Scheduler event. An API ...
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/signal.html
Valid simple_value_specification designators can be specified using stored procedure or function parameters, stored program local variables declared with DECLARE, user-defined variables, system variables, or literals. The warning does not terminate ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
The statement executes a stored procedure that sets the new limit. This is also true for any statement inside a stored procedure; the statement is prepared once, when the stored procedure is first executed. A user variable referenced by a statement ...MySQL now incorporates a transactional data dictionary that stores information about database ...
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/privileges-provided.html
ALTER ROUTINE Enables use of statements that alter or drop stored routines (stored procedures and functions). CREATE ROUTINE Enables use of statements that create stored routines (stored procedures and functions). EXECUTE Enables use of statements ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
Transactions and Stored Programs Transactions and stored program events are related as follows: Stored Procedures Stored procedures operate independently of transactions. A stored procedure can be started within a transaction, and a transaction can ...These tables store transaction events: events_transactions_current: The current transaction event for each ...Within the event ...