Search Results
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/mysql-secure-deployment-guide/8.0/en/secure-deployment-fips.html
MySQL 8.0 supports FIPS (Federal Information Processing Standards) mode, if compiled using OpenSSL, and a FIPS-enabled OpenSSL library and FIPS Object Module are available at runtime. FIPS mode imposes conditions on cryptographic operations such as ...
https://dev.mysql.com/doc/internals/en/store-lock.html
Synopsis virtual THR_LOCK_DATA ** store_lock ( thd, to, lock_type); THD * thd ; THR_LOCK_DATA ** to ; enum thr_lock_type lock_type ; Description This is the store_lock method. The idea with handler::store_lock() is the following: The statement ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
Double-clicking the Add table icon in the Physical Schemas section of the Model Overview tab adds a table with the default name of table1. If a table with this name already exists, the new table is named table2. Adding a new table automatically ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...
https://dev.mysql.com/doc/internals/en/innodb-mutex-rwlock-implementation.html
In MySQL and InnoDB, multiple threads of execution access shared data structures. InnoDB synchronizes these accesses with its own implementation of mutexes and read/write locks. Historically, InnoDB protected the internal state of a read/write lock ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-existing-collections.html
In order to retrieve a Collection object for an existing collection stored in the database call the getCollection() function from a Schema object. Note In most cases it is good practice to create database objects during development time and refrain ...
https://dev.mysql.com/doc/workbench/en/wb-connection-properties.html
When a connection is selected, it is highlighted and its properties are displayed in the properties palette. The following list describes them: caption: The name of the connection. By default, the name is the name of the foreign key and the property ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-handling-errors.html
This program demonstrates handling errors and retrying failed transactions using the NDB API. The source code for this example can be found in storage/ndb/ndbapi-examples/ndbapi_retries/ndbapi_retries.cpp in the NDB Cluster source tree. In this ...
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Client informs about the user account it wants to log into in the Handshake Response Packet. Only then server can look-up the mysql.user ...