MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 111 to 120 of 121 total results

https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html

In both cases, if the DEFINER account is highly privileged, the object may be able to perform sensitive or dangerous operations. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, ...

12.8.3 Character Set and Collation of Function Results

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

Note The REPLACE() function, unlike all other functions, always ignores the collation of the string input and performs a case-sensitive comparison. MySQL has many operators and functions that return a string. This section answers the question: What ...

9.1.1 String Literals

https://dev.mysql.com/doc/refman/5.7/en/string-literals.html

A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...

11.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...

4.2.5 Connection Transport Protocols

https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html

For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...

23.3.1 Trigger Syntax and Examples

https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html

OLD and NEW are MySQL extensions to triggers; they are not case-sensitive. To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, ...

9.4 User-Defined Variables

https://dev.mysql.com/doc/refman/5.7/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

5.5.5.3 Using Version Tokens

https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html

Version Tokens treats token names and values as binary strings, so comparisons are case-sensitive. Before using Version Tokens, install it according to the instructions provided at Section 5.5.5.2, “Installing or Uninstalling Version Tokens”. A ...

2.3.4.8 Starting MySQL as a Windows Service

https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html

On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as a service can also be controlled from the command line using ...

13.3.7 XA Transactions

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

(As with nondistributed transactions, SERIALIZABLE may be preferred if your applications are sensitive to read phenomena. Support for XA transactions is available for the InnoDB storage engine. The MySQL XA implementation is based on the X/Open CAE ...

Displaying 111 to 120 of 121 total results