Search Results
https://dev.mysql.com/doc/refman/8.4/en/values.html
ROW() cannot be empty (but each of the supplied scalar values can be NULL). VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
InnoDB: InnoDB did not allow updating a REDUNDANT table column that was altered with NULL as the default value using the INSTANT algorithm. (Bug #36259487) InnoDB: A schema mismatch was possible when a table was imported with a different sql_mode ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
To restore a MySQL instance from a backup to a database server: Shut down the database server. Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and --innodb_undo_directory options ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Client error messages originate from within the MySQL client library. 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 ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-30.html
Version 8.0.30 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0 and 5.7. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
The Type changed from ALL to range, possible keys (and used key) changed from NULL to i_o_orderdate, and the number of scanned rows changed from 1.5 million to about 33 thousand. This tutorial describes how to use Explain reports to locate and fix ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-last-insert-id.html
In this case, try the following statement as an alternative: SELECT * FROM tbl WHERE auto IS NULL; This alternative method requires that sql_auto_is_null variable is not set to 0. Obtaining the value of column that uses AUTO_INCREMENT after an ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
In this case, try the following statement as an alternative: SELECT * FROM tbl WHERE auto IS NULL; This alternative method requires that sql_auto_is_null variable is not set to 0. Obtaining the value of column that uses AUTO_INCREMENT after an ...