Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.4/en/charset-examples.html
The following examples show how MySQL determines default character set and collation values. Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE ...Notice that there is no problem with storing a latin1 column in a latin2 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
(That is, the implicit statement delimiter is the newline character.) Use the --delimiter option to specify a different delimiter, which enables you to specify statements that span multiple lines or place multiple statements on a single line.
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3056; Symbol: ER_CHANGE_SOURCE_PASSWORD_LENGTH; SQLSTATE: HY000 Message: The password provided for the replication user exceeds the maximum length of 32 characters Error number: 3057; Symbol: ER_USER_LOCK_WRONG_NAME; SQLSTATE: 42000 ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using prepared CALL statements can be used in the following ways: A stored procedure can produce any ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
int mysql_stmt_execute(MYSQL_STMT *stmt) Description mysql_stmt_execute() executes the prepared query associated with the statement handler. The currently bound parameter marker values are sent to server during this call, and the server replaces ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and ...