Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/cli-integration-defining-arguments.html
To pass in multiple parameters, each a single string, no quoting is required: $ mysqlsh -- object function simple string In this case, MySQL Shell gets two arguments - argument 1 is simple, and argument 2 is string. If you want these two strings to ... As mentioned in Section 5.8.2.1, “Command Line Integration for MySQL Shell API Functions”, most of the APIs available in MySQL Shell expect a specific data type for the arguments being ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
To clear the SQL mode explicitly, set it to an empty string using --sql-mode="" on the command line, or sql-mode="" in an option file. ANSI_QUOTES Treat " as an identifier quote character (like the ` quote character) and not as a string quote ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
A stored routine is either a procedure or a function. Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A function can be called from ...A procedure is invoked using a CALL statement (see Section 15.2.1, “CALL Statement”), and can only pass back values using output ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several functions. One set of functions ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Note The quoting function must not be used to escape values. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Use the value ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-information-schema-plugins.html
The initialization function should return 0 for success, 1 if an error occurs. NAME is string-valued with a length of 10 and VALUE is integer-valued with a display width of 20. static ST_FIELD_INFO simple_table_fields[]= { {"NAME", 10, ... This ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\dyn (DYNAMICALLY ALLOCATED ARRAY) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- dyn0dyn.c Dynamic / Dynamic 994 dynamically allocated array There is a single function in the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
MySQL HeatWave AutoML MySQL HeatWave Autopilot MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML has increased the maximum model size from 900MB. (WL #15663) ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-local-infile-handler.html
void mysql_set_local_infile_handler(MYSQL *mysql, int (*local_infile_init)(void **, const char *, void *), int (*local_infile_read)(void *, char *, unsigned int), void (*local_infile_end)(void *), int (*local_infile_error)(void *, char*, unsigned ...It enables application programs to exert control over local (client-side) data file ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE TABLE t (columns) PARTITION BY p_type(p_func(col1, col2,... Note that this process works for ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...