Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Lines terminated by: Specify one or more characters (or an empty string) with which each of the lines are terminated in the imported data file. Fields terminated by: Specify one or more characters (or an empty string) with which each of the fields ... Importing Data Using the Data Import Feature 7.2.1.2 Importing Data Using the Data Import Feature Use the data import feature in the MySQL HeatWave Console to import data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
To run Auto Parallel Load with a non-oci-default SQL mode configuration, specify the configuration using the Auto Parallel Load sql_mode option as a string value. auto_enc: Checks if there is enough memory for string column encoding. mysql> CALL ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-modify.html
It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that are to be modified—a detailed discussion on the SearchConditionStr can be found in Section 4.3.2, “Collection.find()”. If one or more ... The ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented. The ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ... To ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-16.html
For X DevAPI applications, specify connection attributes as a connection-attributes parameter in a connection string, or setting connection-attributes as a dictionary inside the connection settings parameter under the connection-attributes key.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
The default for each column is the empty string, indicating that the variable has not been set since server startup. If a variable with a VARIABLE_SOURCE value other than DYNAMIC is set at runtime, VARIABLE_SOURCE becomes DYNAMIC and VARIABLE_PATH ... The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of ...
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 ...