PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE ...Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE ...See also the notes ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
Note Prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements is interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
You can use the STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses with CREATE TABLE and ALTER TABLE statements to configure optimizer statistics for individual tables. You can manually modify the mysql.innodb_table_stats and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-client-commands.html
Since there is currently no way using ndb_mgm or the mysql client to remove all data from a specific data node or node group, this means that the command succeeds only in the two following cases: After issuing CREATE NODEGROUP in the ndb_mgm client, ...TRUNCATE TABLE does not work for this purpose because this removes only the table data; the data nodes continue to store an NDBCLUSTER table's definition until a DROP TABLE statement is issued that causes the table metadata to be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
Trigger or stored program updates a table having an AUTO_INCREMENT column. In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON ...