Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
This is especially important for columns that make up the primary key for an InnoDB table, because those column values are duplicated within each secondary index. For example, input values might contain quotation marks, semicolons, % and _ wildcard ... The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in your main ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
This can be done by using the IGNORE INDEX index hint as part of the SELECT statement reading the table (see Section 10.9.4, “Index Hints”). This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-main-menu.html
Collect Performance Schema Stats: Provides data to the Query Stats result set view, which includes statement specific information about Timing, Rows processed, Temporary tables, Joins per type, Sorting, and Index usage. SQL Query Menu The Query menu ... When an SQL query tab is selected, the most important items on the main menu bar are the Query and Edit ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
Typographical and Syntax Conventions This manual uses certain typographical conventions: Text in this style is used for SQL statements; database, table, and column names; program listings and source code; and environment variables. Example: “To ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Some variable changes require that you rebuild the FULLTEXT indexes in your tables. Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. After changing any of these options, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
NDB error code QRY_SCAN_ORDER_ALREADY_SET MySQL error DMEC Error message Index scan order was already set in query definition. The following list enumerates all NDB errors of type AE (Application error). Having a table without primary key uses an ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
The driver supports the initial statement being executed only at the time of the initial connection. It does not work when the option parameter MULTI_STATEMENTS is set. no_ssps - 0 In Connector/ODBC 5.2 and after, by default, server-side prepared ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
The driver supports the initial statement being executed only at the time of the initial connection. It does not work when the option parameter MULTI_STATEMENTS is set. no_ssps - 0 In Connector/ODBC 5.2 and after, by default, server-side prepared ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
If the resulting table would have an expression default value that contains a forward reference to a generated column or column with an expression default value, the statement fails. If an expression default value refers to a nondeterministic ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
How do I know how late a replica is compared to the source? In other words, how do I know the date of the last statement replicated by the replica? A.14.4. How do I tell whether a replication source server is using statement-based or row-based ...