Search Results
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
If strict SQL mode is enabled, an error occurs and the column remains unchanged. If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> CALL query_rewrite.flush_rewrite_rules(); ERROR 1644 (45000): Loading of some rule(s) failed. When this occurs, the plugin writes an error message ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
Option Value Meaning 1 Reject the document and produce an error. If srid refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. For geographic SRS geometry arguments, if any argument has a longitude or latitude that ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
Unless the --with-timestamp option is used, the directory specified by --backup-dir must be empty, or the backup operation will fail with an error. If backup_innodb_data_home_dir is an absolute path, its value is used as-is, unless it points to a ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-descriptions.html
Unless specified otherwise, functions returning a pointer return a non-NULL value to indicate success or a NULL value to indicate an error, and functions returning an integer return zero to indicate success or nonzero to indicate an error. When a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-sqlstate.html
const char * mysql_stmt_sqlstate(MYSQL_STMT *stmt) Description For the statement specified by stmt, mysql_stmt_sqlstate() returns a null-terminated string containing the SQLSTATE error code for the most recently invoked prepared statement API ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
The value is used to construct the failure error message of Authentication fails. Error Code Meaning CR_OK Success CR_OK_HANDSHAKE_COMPLETE Do not send a status packet back to client CR_ERROR Error CR_AUTH_USER_CREDENTIALS Authentication failure ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Max syntax error count: [ 100 ] Large complex scripts may contain errors. Further, a syntax error early on can lead to subsequent syntax errors. For these reasons, it is possible to limit the number of errors displayed using this option. Continue on ... This section provides configuration options that affect the SQL editor functionality in MySQL ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
I'm attempting to execute a DELETE query but the query fails with an "Error Code: 1175" error. My MySQL server connection is timing out with an error like "Error Code: 2013. I'm attempting to execute a DELETE query but the query fails with an "Error ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...