Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-string.html
In each key-value pair, the option name and its corresponding value are joined by an equal sign. For the list of option names to use in the connection string, see Section 4.5, “Connector/NET Connection Options Reference”. The following is a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-serverprep.html
For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); After creating ... The first step is using MySQL with BLOB data is to configure the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pem.html
Because this tutorial sets the SslMode option to VerifyFull, you must also provide values for the SslCa, SslCert, and SslKey connection options. "SslCa=ca.pem;" + "SslCert=client-cert.pem;" + "SslKey=client-key.pem;")) Alternatively, if you set the ... The direct use of PEM format certificates was introduced to simplify certificate management in multiplatform environments that include similar MySQL ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
In most cases, this can be solved by doing one of the following things: Add a primary key for the table if one doesn't exist. This error may be related to Keyboard Logger 1.1 from PanteraSoft.com, which is known to interfere with the network ... The ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an application. Functions included in the asyncio API must be used to ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
The second INSERT depends on the value of the newly created primary key of the first. The AUTO_INCREMENT column option for the primary key of the employees table is important to ensure reliable, easily searchable data. Inserting or updating data is ...
https://dev.mysql.com/doc/internals/en/caching.html
(Note that the some of the filenames contain an incorrect spelling of the word “cache.”) Key Cache A shared cache for all B-tree index blocks in the different NISAM files. (mysys/mf_keycash.c) Record Cache This is used for quick scanning of all ...Uses hashing and reverse linked lists for quick caching of the most recently used blocks and quick flushing of changed entries for a specific ...
https://dev.mysql.com/doc/internals/en/cmd-line-utils-directory.html
All the files here are "non-MySQL" files, in the sense that MySQL AB didn't produce them, it just uses them. It should be unnecessary to study the programs in these files unless you are writing or debugging a tty-like client for MySQL, such as ...
https://dev.mysql.com/doc/internals/en/fast-path.html
set --default-auth=sha256_password for the MySQL client, provide it with the servers public-key with --server-public-key=... set --default-authentication-plugin=sha256_password for the MySQL server: 46 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 02 ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The file bears the same name as the table, with an .frm extension.