Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. Collection names are case-sensitive and each collection name must be unique. The following example ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-insert.html
You can use the insert() method with the values() method to insert records into an existing relational table. The insert() method accepts individual columns or all columns in the table. Use one or more values() methods to specify the values to be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-update.html
You can use the update() method to modify one or more records in a table. The update() method works by filtering a query to include only the records to be updated and then applying the operations you specify to those records. To replace a city name ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-hexdump.html
For more information about binary log format, see MySQL Internals: The Binary Log. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in hexadecimal. Master ID: The server ID of the replication source server that created ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. For information about reloading such dump files, see Section 9.4.4, “Reloading Delimited-Text Format Backups”. If you invoke mysqldump with the --tab=dir_name ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 9.4.2, “Reloading SQL-Format Backups”. By default, mysqldump writes information as SQL statements to the ...
https://dev.mysql.com/doc/refman/8.4/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Numbers may be preceded by - or + to indicate a negative or positive value, respectively. Numbers represented in scientific notation ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...
https://dev.mysql.com/doc/refman/8.4/en/open.html
OPEN cursor_name This statement opens a previously declared cursor. For an example, see Section 15.6.6, “Cursors”. ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do ...