Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. With the statement based logging format, all statements affecting BLACKHOLE tables are logged, but their effects ignored. When ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-table-from-file-name.html
Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
The server executable determines its own full path name at startup and uses the parent of the directory in which it is located as the default basedir value. --check-table-functions=value Command-Line Format --check-table-functions=value Introduced ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/ndbapi/en/ndb-foreignkey.html
This section provides information about the ForeignKey class, which models a foreign key on an NDB table. ForeignKey Class Overview ForeignKey() ForeignKey::FkAction ForeignKey::getName() ForeignKey::getParentTable() ForeignKey::getChildTable() ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Use the Columns subtab to display and edit all the column information for a table. You can also add a primary key by checking the PRIMARY KEY check box in the Column Details section of the table editor. You can also use the Columns subtab to change ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
The Indexes subtab contains all of the index information for your table. The following figure shows an example of the layout with the PRIMARY index of the customer table selected and both the index columns and index options shown. Figure 8.15 The ...Click an index name to display the Index Columns section with information about the selected ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
To enable partitioning for your table, check the Enable Partitioning check box. The entries in this table are: Partition Values Data Directory Index Directory Min Rows Max Rows Comment Subpartitioning is also available. This enables the ...
https://dev.mysql.com/doc/refman/8.4/en/database-count-limit.html
The underlying file system may have a limit on the number of files that represent tables. The underlying file system may have a limit on the number of directories.