MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 141 to 150 of 378 total results

https://dev.mysql.com/doc/refman/9.7/en/sys-list-add.html

Adds a value to a comma-separated list of values and returns the result. This function and list_drop() can be useful for manipulating the value of system variables such as sql_mode and optimizer_switch that take a comma-separated list of values.

30.4.5.8 The list_drop() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-list-drop.html

Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified.

12.14 Adding a Collation to a Character Set

https://dev.mysql.com/doc/refman/9.7/en/adding-collation.html

Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The MySQL 9.7 server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is ...

15.7.1.1 ALTER USER Statement

https://dev.mysql.com/doc/refman/9.7/en/alter-user.html

ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... It enables authentication, role, SSL/TLS, ...

14.12 Bit Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html

Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...

13.3.2 The CHAR and VARCHAR Types

https://dev.mysql.com/doc/refman/9.7/en/char.html

The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the ...

12.8.5 The binary Collation Compared to _bin Collations

https://dev.mysql.com/doc/refman/9.7/en/charset-binary-collations.html

This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.

12.3.5 Column Character Set and Collation

https://dev.mysql.com/doc/refman/9.7/en/charset-column.html

Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...

15.1.22 CREATE PROCEDURE and CREATE FUNCTION Statements

https://dev.mysql.com/doc/refman/9.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 ...

15.1.25.5 FOREIGN KEY Constraints

https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html

MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...

Displaying 141 to 150 of 378 total results