Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-enterprise-audit.html
MySQL Enterprise Audit 3.1.2.7 MySQL Enterprise Audit MySQL HeatWave on AWS supports the MySQL Enterprise Audit plugin for MySQL Server 8.1.0 and later. The audit plugin enables the MySQL Server to produce a log file containing an audit record of ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. SMALLINT SMALLINT BIGINT BIGINT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The execute_prepared_stmt_from_app_async routine creates an asynchronous task associated with a specific application user. Application-level asynchronous task lets you filter and track tasks for individual application users using an ...