PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
db The default database for the thread, or NULL if there is none. current_statement The statement the thread is executing, or NULL if it is not executing any statement. The MySQL process list indicates the operations currently being performed by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
When a '0000-00-00' date is used through Connector/ODBC, it is automatically converted to NULL because ODBC cannot handle that kind of date. MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” This is in some cases ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
For example, if you specified NOT NULL and an explicit DEFAULT value, you should also provide them in the ALTER TABLE statement. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
If character_set_results has a value of NULL or binary, no conversion occurs. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
If character_set_results is set to NULL, no conversion is performed and the server returns metadata using its original character set (the set indicated by character_set_system). Metadata is “the data about the data.” Anything that describes the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. For information about restrictions on view use, see Section 23.9, “Restrictions on Views”. The ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
If the DEFAULT clause is missing, the initial value is NULL. type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an ...