PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
If you drop an AUTO_INCREMENT column and then add another AUTO_INCREMENT column, the numbers are resequenced beginning with 1. When replication is used, adding an AUTO_INCREMENT column to a table might not produce the same ordering of the rows on ...
https://dev.mysql.com/doc/refman/8.0/en/call.html
For information about the effect of unhandled conditions on procedure parameters, see Section 15.6.7.8, “Condition Handling and OUT or INOUT Parameters”. To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by ... CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
More generally, MySQL uses the concept of character set repertoire, which can sometimes be used to determine subset relationships among character sets and enable conversion of operands in operations that would otherwise produce an error. For ... In ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as equal. Collations for non-Unicode multibyte character sets For this type of collation, 8-bit (single-byte) and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
This includes characters in the Basic Multilingual Plane (BMP) range (U+0000 to U+FFFF) and supplementary characters outside the BMP range (U+10000 to U+10FFFF). The repertoire for function return values is determined based on the repertoire of only ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata. Figure 7.2 Remote Cloning Operation A remote cloning operation involves a local MySQL server instance (the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
It is cumbersome for applications to directly manage the set of candidate servers for connection attempts, and DNS SRV records provide an alternative: DNS SRV records enable a DNS administrator to map a single DNS domain to multiple servers. An ...A ...
https://dev.mysql.com/doc/refman/8.0/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. The features described in this section enable you to use MySQL as a document store, which is a schema-less, and ...If ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
As of MySQL 8.0.12, extended information is available for SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). The Message value in ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE ...