https://dev.mysql.com/loading-tables.html
For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL values. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> ...Suppose that your pet records can be described as shown ...
https://dev.mysql.com/mysql-cluster-online-add-node-example.html
You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql client. In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes ...
https://dev.mysql.com/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/point-in-time-recovery-positions.html
Instead of specifying dates and times, the --start-position and --stop-position options for mysqlbinlog can be used for specifying log positions. They work the same as the start and stop date options, except that you specify log position numbers ...
https://dev.mysql.com/server-error-reference.html
FOR UPDATE, and so on) consistent between the different transactions or applications that experience the issue. Error number: 1217; Symbol: ER_ROW_IS_REFERENCED; SQLSTATE: 23000 Message: Cannot delete or update a parent row: a foreign key constraint ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/server-options.html
--low-priority-updates Property Value Command-Line Format --low-priority-updates[={OFF|ON}] System Variable low_priority_updates Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Give table-modifying operations ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...If both are present in a column definition, either can occur ...
https://dev.mysql.com/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 5.3, “The mysql System ...
