PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE information_schema_stats_expiry can be set to 0 to have ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. (To update the cached values at any time for a given table, use ANALYZE TABLE.) If there are no cached statistics or statistics ...
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
For example: $> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 4cd4129b3211 container-registry.oracle.com/mysql/community-server:latest "/entrypoint.sh mysq…" 8 seconds ago Up 7 seconds (health: starting) 3306/tcp, 33060-33061/tcp ... Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
In this case, you may have to run OPTIMIZE TABLE or myisamchk -r from time to time to improve performance. Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
These values are imprecise because they represent wall clock time (not CPU or machine time), and because they are affected by factors such as server load and network latency. (For brevity, the “rows in set” line is sometimes not shown in the ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Options on the command line take precedence over values specified in option files and ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-json.html
It is permitted to name log_sink_json multiple times in the log_error_services value. If log_sink_json is named multiple times in the log_error_services value, they all write to the console, which is likely not useful. This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Sometimes people try to insert gbk characters into gb2312, and it works most of the time because gbk is a superset of gb2312. Sometimes adding or changing a <meta> tag suffices to correct the problem: for example, to insure that the user agent ...