Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
As noted in Section 19.5.1.31, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based or mixed format. Temporary tables are not replicated when using row-based or mixed format because there is no need. In ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine types. For example, in a typical scale-out scenario (see Section 19.4.5, “Using ...This ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. See Table 5.3, “Connector/ODBC Option Parameters” and Table 5.4, “Recommended Connector/ODBC ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. See Table 5.3, “Connector/ODBC Option Parameters” and Table 5.4, “Recommended Connector/ODBC ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The file bears the same name as the table, with an .frm extension. | ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
"rest_of_plan": [ { "database": "test", "table": "alias2", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "records": 1, "cost": 20.2, "chosen": true We choose ref access on the primary key of alias2.
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-adapter.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using array adapters of the type defined in common/array_adapter.hpp (see Section 2.5.15, “Common Files for NDB API Array Examples”). static ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
This is true for working with collections and for working with relational tables. A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
If set, the routine searches for vector store tables in this schema. This parameter cannot be used in combination with the tables parameter. vector_store_columns: optional parameter which specifies column names for finding relevant vector and ...