Search Results
https://dev.mysql.com/doc/refman/26.7/en/replication-features-charset.html
A good workaround is to state the character set and collation explicitly in CREATE TABLE statements. The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set ...
https://dev.mysql.com/doc/refman/26.7/en/replication-features-sql-mode.html
The replica applies the statement using the recorded mode, so utf8 character set and collation aliases resolve in the same way on the source and replica. Using different server SQL mode settings on the source and the replica may cause the same ...
https://dev.mysql.com/doc/refman/26.7/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/26.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/26.7/en/set-character-set.html
SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...
https://dev.mysql.com/doc/refman/26.7/en/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. Descriptions for those forms that are not associated with a specific server capability appear in subsections ...
https://dev.mysql.com/doc/refman/26.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/26.7/en/spatial-geohash-functions.html
These geohash functions are available: ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection character set and collation. Geohash is a system for encoding latitude and longitude ...
https://dev.mysql.com/doc/refman/26.7/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/26.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...