Search Results
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
For example: mysql> ssl_session_data_print ~/private-dir/session.txt Session data are obtained in the form of a null-terminated, PEM encoded ANSI string. MySQL client programs may elect to resume a prior SSL session, provided that the server has ...
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
The expression is unknown (that is, NULL) if the subquery produces no rows. Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.4/en/select.html
This exception may not apply to const or system tables that are used on the NULL-complemented side of an outer join (that is, the right-side table of a LEFT JOIN or the left-side table of a RIGHT JOIN. SELECT [ALL | DISTINCT | DISTINCTROW ] ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
The value displayed for the Create Procedure or Create Function field is NULL if you have only CREATE ROUTINE, ALTER ROUTINE, or EXECUTE. SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 7. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
For values that depend on the getrusage() system call, NULL is returned on systems such as Windows that do not support the call. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release.
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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 ...