MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 51 to 59 of 59 total results

« Previous
4
5
6
Next »

https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html

A multiple-column index can be considered a sorted array, the rows of which contain values that are created by concatenating the values of the indexed columns. MySQL can create composite indexes (that is, indexes on multiple columns). For certain ...

12.4.3 Logical Operators

https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html

Table 12.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...

12.18 Functions Used with Global Transaction Identifiers (GTIDs)

https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html

The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/5.7/en/features.html

For example: mysql> SELECT CONCAT(first_name, ' ', last_name) -> FROM citizen -> WHERE income/dependents > 10000 AND age > 30; Full support for SQL GROUP BY and ORDER BY clauses. Support for group functions (COUNT(), AVG(), STD(), SUM(), MAX(), ...

12.13 Encryption and Compression Functions

https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html

For example: ENCODE('cleartext', CONCAT('my_random_salt','my_secret_password')) A new random salt value must be used whenever a password is updated. If you want to store these results, use a column with a VARBINARY or BLOB binary string data type.

13.1.16 CREATE PROCEDURE and CREATE FUNCTION Statements

https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html

By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...

13.7.3.1 CREATE FUNCTION Statement for Loadable Functions

https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html

(CREATE FUNCTION is also used to created stored functions; see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...

10.9.1 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)

https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html

The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP ...

12.1 Built-In Function and Operator Reference

https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...