Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
For the current user, the SELECT privilege for the mysql.user system table is required for display of the password hash in the IDENTIFIED AS clause; otherwise, the hash displays as <secret>. Password hash values displayed in the IDENTIFIED WITH ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
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 ...