Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL:1999 and later permits such nonaggregates per optional feature T301 if they are functionally dependent on GROUP BY columns: If such a relationship exists between name and custid, the query is legal. If the ONLY_FULL_GROUP_BY SQL mode is enabled ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
parameter_type_elements: Information about stored procedure and function parameters, and about return values for stored functions. view_routine_usage: Information about dependencies between views and stored functions used by them. Object Information ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of SQL functions which are permitted in partitioning expressions, see Section 26.6.3, ... This ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-32.html
An Important Update Entity Framework 6 Notes Pluggable Authentication Functionality Added or Changed Bugs Fixed An Important Update The Connector/NET MySql.Data version 8.0.32.1 NuGet package now is released and the newer package supersedes the ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-26.html
(WL #14586) Functionality Added or Changed Applications that use Connector/ODBC now can define query attribute metadata on a per-query basis, without the use of workarounds such as specially formatted comments included in query strings. (Bug ...(WL ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-3-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed The X DevAPI and Classic API were separated into their own packages. Previously, this functionality was supported only by the pure Python implementation. Both implementations ...The mysql-connector-python package continues to install the Classic API, and a new mysqlx-connector-python package installs the X ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-document-ids.html
The ISBN is a string with a length of 13 characters, which is well within the length limit of 32 characters for the _id field. var book = myColl.find('_id = "978-1449374020"').execute(); Currently, X DevAPI does not support using any document field ... This section describes what a document ID is and how to work with ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-syntax.html
For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. You can always store an exact integer value in a BIGINT column by storing it using a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
log_bin_trust_function_creators: If equal to 0 (default), then when --log-bin is used, stored function creation is allowed only to users having SUPER privilege and only if function created does not break binary logging. Set to empty string to ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Here is an example client error message, as displayed by the mysql client: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0) Each client error message includes an error code, SQLSTATE value, and message ...