Search Results
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
TRUNCATE TABLE can be used with Performance Schema summary tables, but the effect is to reset the summary columns to 0 or NULL, not to remove rows. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
NULL values sort first for ascending sorts, last for descending sorts. However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-modify.html
The modify(SearchConditionStr) function is for modifying documents in a collection, similar to an UPDATE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that are to be ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
mysql> SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | PS_CURRENT_THREAD_ID() | +------------------------+ | 52 | +------------------------+ mysql> SELECT PS_THREAD_ID(CONNECTION_ID()); +-------------------------------+ | ... MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-sql-mode.html
This property is used to retrieve and set the SQL Modes for the current connection. The value should be a list of different modes separated by comma (","), or a sequence of modes, preferably using the constants.SQLMode class. To unset all modes, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-sql-mode.html
This property is used to retrieve and set the SQL Modes for the current connection. The value should be a list of different modes separated by comma (","), or a sequence of modes, preferably using the constants.SQLMode class. To unset all modes, ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-enum.html
ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 13.3.5, “The ENUM Type”, and Section 13.3.6, “The SET Type”. Unless strict mode is disabled (not recommended, but see ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files. IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...