Search Results
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/refman/8.4/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as a service can also be controlled from the command line using ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
X Plugin supports compression of messages sent over X Protocol connections. Connections can be compressed if the server and the client agree on a mutually supported compression algorithm. Enabling compression reduces the number of bytes sent over ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). Now pruning continues in such cases, but with a warning printed in the error log stating that ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-num-fields.html
unsigned int mysql_num_fields(MYSQL_RES *result) To pass a MYSQL* argument instead, use unsigned int mysql_field_count(MYSQL *mysql). You can get the number of columns either from a pointer to a result set or to a connection handler. You would use ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open ...