Search Results
https://dev.mysql.com/doc/refman/9.7/en/vector.html
To declare a VECTOR column of the default length, define it as VECTOR with no parentheses following; trying to define a column as VECTOR() (with empty parentheses) raises a syntax error. A VECTOR is a structure that can hold up to a specified ...
https://dev.mysql.com/doc/refman/9.7/en/what-is-crashing.html
Use the “copy and paste” method for any output and error messages from programs and log files. This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/windows-installation.html
include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation Silent Installation Methods Use the standard msiexec options for ... MySQL is available for Microsoft Windows 64-bit operating systems ...
https://dev.mysql.com/doc/refman/9.7/en/windows-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%windows%'; +------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +------------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/9.7/en/windows-postinstallation.html
For example, the program may fail with an error, or you may not be able to view all databases. GUI tools exist that perform most of the tasks described in this section, including: MySQL Configurator: Used to configure the MySQL server. If ...
https://dev.mysql.com/doc/refman/9.7/en/windows-upgrading.html
If you encounter errors, see Section 2.3.4, “Troubleshooting a Microsoft Windows MySQL Server Installation”. To upgrade MySQL on Windows, either download and execute the latest MySQL Server MSI or use the Windows ZIP archive distribution. Note ...
https://dev.mysql.com/doc/refman/9.7/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-options-variables.html
In this case, the server could also produce error messages for other X Plugin settings because it cannot recognize them. This section describes the command options and system variables that configure X Plugin, as well as the status variables ...
https://dev.mysql.com/doc/refman/9.7/en/xa-statements.html
If you use any of those statements but specify an xid value that does not correspond to some existing XA transaction, an error occurs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid ...