Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...raw_as_string ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a number that tells us how good a match is. Vector Space, which MySQL sometimes calls "natural language", ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. The .MYI file has two parts: the header information and the key values. So the next sub-sections will be "The .MYI Header" and "The .MYI Key Values". The .MYI Header A .MYI file begins ...
https://dev.mysql.com/doc/internals/en/write-row.html
Synopsis virtual int write_row ( buf); byte * buf ; Description This is the write_row method. No [custom-engine.html#custom-engine-api-reference-extra extra()] hint is given currently if a bulk load is happening. buf is a byte array of data with a ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines messages. Message ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
sever-side generated primary keys (like AUTO_INCREMENT) rows-found, rows-matched, rows-affected CURRENT_SCHEMA Sent after statement that changes the current schema like USE ... Global Notices Global Notices are sent by the server in case of events ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-0.html
This section provides information about keywords and reserved words in MySQL 8.0. MySQL 8.0 Keywords and Reserved Words MySQL 8.0 New Keywords and Reserved Words MySQL 8.0 Removed Keywords and Reserved Words MySQL 8.0 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-4.html
This section provides information about keywords and reserved words in MySQL 8.4. MySQL 8.4 Keywords and Reserved Words MySQL 8.4 New Keywords and Reserved Words MySQL 8.4 Removed Keywords and Reserved Words MySQL 8.4 Keywords and Reserved Words ...