Search Results
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.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. Example The following example demonstrates how to create and populate a table using ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-named-windows.html
Windows can be defined and given names by which to refer to them in OVER clauses. If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-apps-windows-notes.html
On Windows, applications can be built in different build configurations, which determine the type of the C++ runtime library that is used by the final executable: An application can be built in 32-bit or 64-bit mode. To build Connector/C++ ... This ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-scaffold-example.html
The resulting entities are created and mapped to the tables in the specified database. For an overview of the requirements to use EF Core with MySQL, see Table 4.3, “Connector/NET Versions and Entity Framework Core Support”). Additional ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
The applications do not need to hardcode table and column names, complicated queries, and so on. When security is paramount, stored procedures keep applications from directly manipulating tables, or even knowing details such as table and column ...