PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
To update invisible columns for UPDATE statements, name them and assign a value, just as for visible columns. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/mysql-installer-catalog-dashboard.html
By default, and when an Internet connection is present, MySQL Installer attempts to update the catalog at startup every seven days. You can also update the catalog manually from the dashboard (described later). An up-to-date catalog performs the ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/server-options.html
If an upgrade is necessary and supported, 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, and reinitializes the data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized 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/doc/refman/8.0/en/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/doc/refman/8.0/en/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 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For example, to add date values, use DATE_ADD(); see Section 14.7, “Date and Time Functions”. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the ...