Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/manifest-usage.html
Each backup directory includes some files in the meta subdirectory that detail how the backup was produced, and what files it contains. The files containing this information are known collectively as the manifest. mysqlbackup produces these files ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
The following sections describe the command-line options for the different modes of operation of mysqlbackup. Use the hyperlinks at the option names to jump to the detailed descriptions for the options. Note The command options can also be ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling mysql_library_init(). Initialize a connection handler by calling mysql_init() and connect ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-binary-log-interface-usage.html
The following simple example program demonstrates the binary log C API functions. Program notes: mysql is assumed to be a valid connection handler. The initial SET statement sets the @source_binlog_checksum user-defined variable that the server ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL statement.
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
Each user can be granted a given single role to, in effect, be granted the appropriate set of privileges. The account for the proxied user must exist and be granted the privileges to be assumed by the proxy user. The server checks statements ...The ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
GRANT and REVOKE assign privileges to and revoke privileges from accounts. Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant Tables”. To ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
For example, if a user can grant the SELECT and UPDATE privileges to regular accounts, then with SYSTEM_USER the user can also grant SELECT and UPDATE to system accounts. Account manipulation includes creating and dropping accounts, granting and ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
Granted roles include those granted explicitly to the user and those named in the mandatory_roles system variable value. Of these, some can request that the MySQL server itself map proxy users according to granted proxy privileges: ... The MySQL ...