Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-select.html
Select All Records To issue a query that returns all records from an existing table, use the select() method without specifying search conditions. You can use the select() method to query for and return records from a table in a database. The X ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
To disable interactive history on Unix, first delete the .mysql_history file, if it exists (previous entries are recalled otherwise). This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status. Note For some Linux platforms, MySQL installation ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-to-other-server.html
On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE statements that create the database if it does exist and make it the default database for the reloaded data.
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
CHECK constraints cannot refer to columns that have the AUTO_INCREMENT attribute, nor can the AUTO_INCREMENT attribute be added to existing columns that are used in CHECK constraints. MySQL supports an extension for optionally specifying the ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-overview.html
Typical users aim to get the best database performance out of their existing software and hardware configurations. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
These rules also apply to existing nonpartitioned tables that you wish to partition using ALTER TABLE ... This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
Section 26.3, “Partition Management”, covers methods of adding, removing, and altering partitions in existing partitioned tables. Note Table partitioning differs from partitioning as used by window functions. In MySQL 8.4, partitioning support ...