PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all uppercase), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Unlike the case with other partitioning types, columns used for partitioning by KEY are not restricted to integer or NULL values. This is a known issue in MySQL 5.7 which is addressed in MySQL 8.0, where this permissive behavior is deprecated, and ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. If you refer to a variable that has not been initialized, it has a value of NULL and a type of ...A ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
At this time, there are no active replica threads, so the THREAD_ID columns are NULL and the SERVICE_STATE columns have a value of OFF. After STOP SLAVE, the THREAD_ID columns become NULL and the SERVICE_STATE columns for threads that no longer ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html
--character-sets-dir=name Command-Line Format --character-sets-dir=path Type String Default Value [none] Directory where character sets are. --connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
MySQL displays DATE values in 'YYYY-MM-DD' format, but permits assignment of values to DATE columns using either strings or numbers. MySQL displays DATETIME values in 'YYYY-MM-DD hh:mm:ss[.fraction]' format, but permits assignment of values to ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...