PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/update.html
With the IGNORE modifier, the update statement does not abort even if errors occur during the update. Rows updated to values that would cause data conversion errors are updated to the closest valid values instead. (This is because the order in which ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... The name can be used in function calls with or without following whitespace, but ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. The Event Scheduler writes information about event execution that terminates with an error or warning ...See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
Final instrument names correspond to server commands and SQL statements: Server commands correspond to the COM_xxx codes defined in the mysql_com.h header file and processed in sql/sql_parse.cc. Some final instrument names are specific to error ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application. Important Because X Plugin is not a mandatory plugin, it does not ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-find.html
mysql-js> db.countryinfo.find() [ { "GNP": 828, "Code:": "ABW", "Name": "Aruba", "IndepYear": null, "geography": { "Continent": "North America", "Region": "Caribbean", "SurfaceArea": 193 }, "government": { "GovernmentForm": "Nonmetropolitan ... You ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-find.html
mysql-py> db.countryinfo.find() [ { "GNP": 828, "Code:": "ABW", "Name": "Aruba", "IndepYear": null, "geography": { "Continent": "North America", "Region": "Caribbean", "SurfaceArea": 193 }, "government": { "GovernmentForm": "Nonmetropolitan ... You ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
Each plugin_library is the name of a library file that contains plugin code, and each name is the name of a plugin to load. Alternatively, the INSTALL PLUGIN statement causes the server to load the plugin code from the library file at runtime: ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. Here are some reasons the Can't connect to local MySQL server error might occur: mysqld is not running on the local host. If ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
This mode causes compiler warnings to become errors, so disabling it may enable compilation to proceed. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential... If you ...