PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/signal.html
It is illegal to assign NULL to a condition information item in a SIGNAL statement. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics ...
https://dev.mysql.com/doc/refman/9.7/en/silent-column-changes.html
Columns that are part of a PRIMARY KEY are made NOT NULL even if not declared that way. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
For general information about stored routines in MySQL, see Section 27.2, “Using Stored Routines”. The MLE component provides a number of loadable functions for working with MLE user sessions. These functions are listed and described here: ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/refman/9.7/en/start-group-replication.html
You cannot specify an empty or null string, or omit the USER option if PASSWORD is specified. START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the ...
https://dev.mysql.com/doc/refman/9.7/en/start-replica.html
The option cannot be set to an empty or null string. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html
oe [NOT] IN (SELECT ie ...) The predicate is IN or NOT IN and a result of UNKNOWN (NULL) has the same meaning as a result of FALSE. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-file-io-type.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize file I/O, grouped by host and event type. By default, ...