Search Results
https://dev.mysql.com/doc/refman/8.4/en/insert.html
TABLE, the statement returns an information string in this format: Records: N1 Duplicates: N2 Warnings: N3 If you are using the C API, the information string can be obtained by invoking the mysql_info() function. For example, inserting the string ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-autocompletion.html
For example: Display all 118 possibilities? (y or n) SQL Autocompletion API The autocompletion API is exposed to developers through the following functions: JavaScript: shell.autoCompleteSql(statement, options) Python: ...functions: candidate MySQL ... MySQL Shell supports autocompletion of text preceding the cursor by pressing the Tab ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-19.html
(WL #13497) Functionality Added or Changed Connector/C++ now supports the use of DNS SRV records to specify multiple hosts: Session and session-pool creation accepts a URI scheme of mysqlx+srv:// that enables the DNS SRV feature in connect strings.
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
With the mysql_info() C API function, you can find out how many rows were copied by ALTER TABLE. Running ALTER TABLE tbl_name FORCE on an InnoDB table performs the same function. ADD, if the column has an expression default value that uses a ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-reporting-create-registering.html
The syntax for the method is as follows: shell.registerReport(name, type, report[, description]) Where: name is a string giving the unique name of the report. type is a string giving the report type which determines the output format, either ... To ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-simple.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using local functions. It then reads the columns back and extracts the data from them using local functions. (Bug #70550, Bug #17592990) #include ...See Section 2.5.15, “Common Files for NDB API Array Examples”, for listings of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
Data Memory, Index Memory, and String Memory DataMemory and IndexMemory are [ndbd] parameters specifying the size of memory segments used to store the actual records and their indexes. StringMemory Version (or later) NDB 8.4.0 Type or units % or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgm.html
Its value lies in providing a set of commands for checking the cluster's status, starting backups, and performing other administrative functions. --connect-string Command-Line Format --connect-string=connection_string Type String Default Value ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
Note MySQL Configurator CLI functionality was added in MySQL Configurator 9.2.0. socket N/A pipe-name, named-pipe-name, named-pipe, pipename string N/A MYSQL configure, reconfigure enable-named-pipes=true Specifies the pipe name to use when ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
A file name can be specified at runtime, using a SET statement: SET GLOBAL innodb_buffer_pool_filename='file_name'; You can also specify a file name at startup, in a startup string or MySQL configuration file. Each page that is stored in or read ...