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/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For the preceding example, if t2 contains any rows, even rows with nothing but NULL values, the EXISTS condition is TRUE. For example: SELECT column1 ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
Several SHOW statements accept a WHERE clause that provides more flexibility in specifying which rows to display. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Why does my GUI front end or browser display CJK characters incorrectly in my application using Access, PHP, or another API? A.11.10. Make sure that the problem is not with the browser or other application, rather than with MySQL. For example you ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
The remote server processes the statement and the local server retrieves any result that the statement produces (an affected-rows count or a result set). To read a result set, it uses mysql_store_result() and fetches rows one at a time using ...
https://dev.mysql.com/doc/refman/8.0/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a row exists, the fetched columns are stored in the named variables. If no more rows are ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
row *************************** TABLE_ID: 71 NAME: col1 POS: 0 MTYPE: 6 PRTYPE: 1027 LEN: 4 HAS_DEFAULT: 0 DEFAULT_VALUE: NULL *************************** 2. row *************************** TABLE_ID: 71 NAME: col2 POS: 1 MTYPE: 2 PRTYPE: 524542 LEN: ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-being-deleted-table.html
The INNODB_FT_BEING_DELETED table has these columns: DOC_ID The document ID of the row that is in the process of being deleted. This value is used when you perform text searches, to skip rows in the INNODB_FT_INDEX_TABLE table before data for ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
DOC_COUNT The number of rows in which this word appears in the FULLTEXT index. Before information for newly inserted rows appears in INNODB_FT_INDEX_TABLE, the FULLTEXT index cache must be flushed to disk. The INNODB_FT_INDEX_TABLE table provides ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
row *************************** TABLE_ID: 71 NAME: test/t1 STATS_INITIALIZED: Initialized NUM_ROWS: 1 CLUST_INDEX_SIZE: 1 OTHER_INDEX_SIZE: 0 MODIFIED_COUNTER: 1 AUTOINC: 0 REF_COUNT: 1 Notes This table is useful primarily for expert-level ... The ...