PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Does MySQL have a NOW() function with fractions of seconds? A.1.7. Which version of MySQL is production-ready (GA)? MySQL 9.4, 8.4, and 8.0 are actively ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
You can get a fresher snapshot for your queries by committing the current transaction and after that issuing new queries. A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time.
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
Enabling innodb_stats_on_metadata may reduce access speed for schemas that have a large number of tables or indexes, and reduce stability of execution plans for queries that involve InnoDB tables. See Section 8.2.1.20, “Avoiding Full Table ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) Indicates by ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 10.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
In this example, memory instrument data is queried in the Performance Schema memory_summary_global_by_event_name table, which summarizes data by EVENT_NAME. The following example demonstrates how to use Performance Schema and sys schema to monitor ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
Opening a Code Editor Before opening a code editor that can execute queries against a MySQL server, a connection needs to be established: Open the Server Explorer pane through the View menu, or with Control + W, K. This section explains how to use ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Queries can be displayed vertically by terminating the query with \G instead of a semicolon. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling ...