Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
In a MySQL server, tables are very long-lived objects, and are often accessed by multiple applications written in different languages. cnx = mysql.connector.connect(user='scott') cursor = cnx.cursor() A single MySQL server can manage multiple ...
https://dev.mysql.com/doc/internals/en/authentication-method-mismatch.html
However, this behavior is not yet implemented in the current mysql client library. Assume that client wants to log in as user U and that user account uses authentication method M. Note The missmatch can happen even if client and server used the ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-myisam.html
We will begin by mentioning that myisam is one of what we call the MySQL storage engine directories. Key handling programs on mysql-5.0/myisam: size name comment ---- ---- ------- 4668 mi_rkey.c for random key searches 3646 mi_rnext.c for next-key ...But the files in those directories are mostly analogues of what's in the myisam directory, and the myisam directory is sort of a ...
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...
https://dev.mysql.com/doc/internals/en/innodb-user-records.html
In the User Records part of a page, you'll find all the records that the user inserted. There are two ways to navigate through the user records, depending whether you want to think of their organization as an unordered or an ordered list. If you ...
https://dev.mysql.com/doc/internals/en/parsing-key-information.html
Many of the index methods pass a byte array named *key that identifies the index entry to be read in a standard format. Your storage engine will need to extract the information stored in the key and translate it into its internal index format to ...
https://dev.mysql.com/doc/internals/en/transformations-row-in.html
It will be the same for other subqueries, except for the WHERE clause. To rewrite a row IN subquery, the method used is Item_in_subselect::row_value_transformer. It works in almost the same way as the scalar analog, but works with Item_cache_row ...
https://dev.mysql.com/doc/ndbapi/en/mgm-concepts.html
This section describes concepts basic to the NDB Cluster MGM API. NdbMgmHandle Working with Log Events Structured Log Events NdbMgmHandle Each MGM API function needs a management server handle of type NdbMgmHandle. This handle is created by calling ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-tablemetadata.html
NDB implements a primary key as both an ordered index and a unique index, and might be viewed through the NDB API adapter as two indexes, but through a MySQL adapter as a single index that is both unique and ordered. The indexes array of ...
https://dev.mysql.com/doc/x-devapi-userguide/en/error-handling.html
When writing scripts for MySQL Shell you can often simply rely on the exception handling done by MySQL Shell. The default error handling can be changed by creating a custom SessionContext and passing it to the mysqlx.getSession() function. For all ...