Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-remove.html
You can use the remove() method to delete some or all documents from a collection in a schema. The X DevAPI provides additional methods for use with the remove() method to filter and sort the documents to be removed. Remove Documents Using ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-delete.html
You can use the delete() method to remove some or all records from a table in a database. The X DevAPI provides additional methods to use with the delete() method to filter and order the records to be deleted. Delete Records Using Conditions The ...
https://dev.mysql.com/doc/refman/8.4/en/null-values.html
The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string types. For text file import or export operations performed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-account-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. To see connection ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary Tables”). To permit assessment at a more fine-grained ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous transactions. This procedure does not require taking the server offline and is suited to use in ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that apply. When using --binlog-do-db or --binlog-ignore-db, the process is similar, but the options ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...