Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--set-collation=name Command-Line Format --set-collation=name Type String Specify the collation to use for sorting table indexes. --correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-config-values.html
row *************************** Name: HostName Node: 2 Type: string Default: localhost Minimum: Maximum: Required: N Current: 127.0.0.1 *************************** 3. row *************************** Name: HostName Node: 3 Type: string Default: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-failover.html
You can use the following query to obtain the needed records from the ndb_binlog_index table on the source: mysqlS'> SELECT -> @file:=SUBSTRING_INDEX(next_file, '/', -1), -> @pos:=next_position -> FROM mysql.ndb_binlog_index -> WHERE epoch = ... In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html
To see a command-specific help message, invoke mysql_config_editor as follows, where command is a command other than help: mysql_config_editor command --help --debug[=debug_options], -# debug_options Command-Line Format --debug[=debug_options] Type ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
INTO OUTFILE.) To enable data files to be written using a different format, mysqldump supports these options: --fields-terminated-by=str The string for separating column values (default: tab). This section describes how to use mysqldump to create ...
https://dev.mysql.com/doc/refman/8.4/en/null-values.html
Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string types. The NULL value means “no data.” NULL can be written in any lettercase. For text file import or export operations performed ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
The rules for escape sequences in option files differ slightly from the rules for escape sequences in string literals in SQL statements. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. Range columns partitioning is similar to range partitioning, but enables you to define partitions ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when using the >, <, >=, <=, BETWEEN, !=, or <> operators, or LIKE comparisons if the argument to LIKE is a constant string that does not start with ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...