Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
(In the worst case, each character may need to be encoded as using two bytes, and there must be room for the terminating null byte.) When mysql_real_escape_string_quote() returns, the contents of to is a null-terminated string. The return value is ... 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 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
(In the worst case, each character may need to be encoded as using two bytes, and there must be room for the terminating null byte.) When mysql_real_escape_string() returns, the contents of to is a null-terminated string. The return value is the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
When mysql_hex_string() returns, the contents of to is a null-terminated string. The return value is the length of the encoded string, not including the terminating null byte. Return Values The length of the encoded string that is placed into to, ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. Returns NULL if X is not in the range -1 to 1, or if X is NULL. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns ...An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT ...
https://dev.mysql.com/doc/refman/8.4/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...Examples: SELECT 'abc'; SELECT _latin1'abc'; SELECT _binary'abc'; SELECT _utf8mb4'abc' COLLATE utf8mb4_danish_ci; Character set introducers and the COLLATE clause are implemented according to standard SQL ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...If explicit COLLATE Y and COLLATE Z occur, raise an ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-escape-string.html
Syntax: str = ccnx.escape_string(str_to_escape) Uses the mysql_escape_string() C API function to create an SQL string that you can use in an SQL statement. Raises a TypeError exception if the value does not have a Unicode, bytes, or (for Python 2) ...