Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object Storage. CREATE EXTERNAL TABLE table_name (col_name data_type ...
https://dev.mysql.com/doc/refman/9.7/en/using-encrypted-connections.html
Suppose that you want to connect using an account that has no special encryption requirements or that was created using a CREATE USER statement that included the REQUIRE SSL clause. For additional information about the REQUIRE clause, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/implicit-commit.html
This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. CREATE TABLE and DROP TABLE statements do not commit ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
Create a new schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. This quickstart shows how to set up a GenAI-powered Help Chat that uses the information available in MySQL HeatWave User Guide to provide answers to ...Note This quickstart assumes that you are familiar with MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
skip_invalid_accounts Skips user accounts created with external authentication plugins that are not supported in MySQL HeatWave on AWS. From MySQL Shell 8.0.26, this option also removes user accounts that do not have passwords set, except where an ...loadDump command only allows import of dumps created with the ocimds option ... MySQL Server Compatibility 7.1.2 MySQL Server Compatibility MySQL HeatWave on AWS has several ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-windows-5-2.html
You should see a window similar to the following when you open the ODBC Data Source Administrator: Figure 5.2 ODBC Data Source Administrator Dialog To create a System DSN (which will be available to all users), select the System DSN tab. To create a ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows-5-2.html
You should see a window similar to the following when you open the ODBC Data Source Administrator: Figure 5.1 ODBC Data Source Administrator Dialog To create a System DSN (which will be available to all users), select the System DSN tab. To create a ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...