Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
Note For an explanation and example of the differences between this function and JSON_MERGE_PRESERVE(), see JSON_MERGE_PATCH() compared with JSON_MERGE_PRESERVE(). The functions in this section modify JSON values and return the result.
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD DATA syntax. Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 ...
https://dev.mysql.com/doc/refman/8.4/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. Note mysql_real_escape_string() fails and produces an ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
This section summarizes how the MySQL Workbench 8.0 release series progressed with each minor release. New requirements for the CHANGE MASTER TO replication statement (row format, primary key check). Failed login attempts and password lock time in ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL Connector/J. Questions 3.14.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL Connector/J. Questions 16.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: ...