Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-security.html
paranoid Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? Default Value false Since Version 3.0.1 serverRSAPublicKeyFile File path to the server RSA public key ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
To specify the statement to prepare, pass the MYSQL_STMT pointer and the statement string to mysql_stmt_prepare(). When you call mysql_stmt_execute(), MySQL use the value stored in the variable in place of the corresponding parameter marker in the ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI routine. Vector embeddings are a numerical ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. This section describes how to generate vector embeddings using the ML_EMBED_ROW routine. Vector embeddings are a numerical representation of the text ...
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/internals/en/replication-correct.html
If a column only exists on the slave (or if application-specific logic ensures that only NULL values are inserted on the master), then the AUTOINCREMENT attribute can be used on the slave. If the slave has a non-NULL constraint (PK or NOT NULL), ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to create ...