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/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If the older ext/mysql extension must be used, then for escaping use the mysql_real_escape_string_quote() function and not mysql_escape_string() or addslashes() because only mysql_real_escape_string_quote() is character set-aware; the other ...If ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
With one exception, the default value specified in a DEFAULT clause must be a literal constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased in length. All credentials are stored in the authentication_string column, ... Before downgrading from MySQL 5.7, review the information in this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
It is also subject to future removal.) ConnectionMap Version (or later) NDB 7.5.0 Type or units string Default [...] Range ... HeartbeatThreadPriority Version (or later) NDB 7.5.0 Type or units string Default [...] Range ... (NDB 7.5.0) In an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
See Section 8.4.2.2, “Optimizing for Character and String Types” for reasons why a binary VARCHAR column is sometimes preferable to an equivalent BLOB column. Rather than testing for equality against a very long text string, you can store a hash ... When storing a large blob containing textual data, consider compressing it ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
If the GTID has already been used, no error is raised, and the auto-skip function is used to ignore the transaction. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a ... The ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The client supplies the credentials specified in the row (for example, a password), as indicated by the authentication_string column. The authentication method implemented by the plugin that authenticates the client may or may not use the password ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? A.1.7. (However, the query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0.) The query cache operates on the server level, caching complete result sets matched with the ...Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? ...
https://dev.mysql.com/doc/refman/5.7/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...