Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. The MySQL client/server protocol provides for the use of prepared statements. This ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. Prepared statements transmit data between the client and server using C language ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-select-db.html
In subsequent queries, this database is the default for table references that include no explicit database specifier. int mysql_select_db(MYSQL *mysql, const char *db) Description Causes the database specified by db to become the default (current) ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-daemon-plugins.html
To verify plugin installation, examine the INFORMATION_SCHEMA.PLUGINS table or use the SHOW PLUGINS statement. A daemon plugin is a simple type of plugin used for code that should be run by the server but that does not communicate with it. This ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-keyring-plugins.html
To verify plugin installation, examine the INFORMATION_SCHEMA.PLUGINS table or use the SHOW PLUGINS statement (see Obtaining Server Plugin Information). MySQL Server supports a keyring service that enables internal server components and plugins to ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-11.html
It is suitable for use with MySQL Server versions 8.0, 5.7, 5.6, and 5.5. Functionality Added or Changed Bugs Fixed Functionality Added or Changed X DevAPI: The locking options lockShared() and lockExclusive(), available when retrieving data from ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-12.html
It is suitable for use with MySQL Server versions 8.0, 5.7, 5.6, and 5.5. (WL #9955) Connector/J now retrieves the MySQL keyword list from the INFORMATION_SCHEMA.KEYWORDS table on the MySQL server when a connection session is established. Version ...