Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
To address this issue, use the CONCAT() function in your queries. The use of CONCAT() forces Excel to treat the value as a string, which Excel will then parse and usually correctly identify the embedded information. The fix is to use OPTION=16384 in ... The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, Microsoft Access and the various programming languages supported within ASP and Microsoft Visual ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
The following SELECT statement includes the mysql_query_attribute_string() loadable function that is used to retrieve the two attributes decared previously and then prints the results. For more readable and convenient syntax, the $ symbol is used in ... The MySqlCommand class represents a SQL statement to execute against a MySQL ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
2164 1 80 Additional flags, and scale if decimal/numeric 2168 1 fe Data type (fe=char, 02=smallint, 03=int, etc.) see enum field_types in include/mysql_com.h 2169 1 08 Character set or geometry type (later) ?? ?? Column names again, defaults, ...
https://dev.mysql.com/doc/internals/en/miscellaneous-options.html
For Autotools MySQL build options that have CMake equivalents, the normal mapping from an Autotools option to the CMake option is to convert uppercase, remove leading dashes, replace dashes with underscores, and add a leading -D.
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-blob-clob-processing.html
blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Note that this value cannot exceed the value of 'maxAllowedPacket' and, if that is the case, then this value will be corrected automatically. Since Version ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based filtering. The value for either variable can be NULL or a string ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. For example: ALTER USER user ...The ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced ...
https://dev.mysql.com/doc/refman/8.4/en/year.html
YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. As 1- or 2-digit strings in the range '0' to '99'. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. As the ...