PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-secure-installation.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type ... This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlcheck.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldm-options.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Type Enumeration ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump-delimited-text.html
--fields-optionally-enclosed-by=char The character within which to enclose non-numeric column values (default: no character). This section describes how to use mysqldump to create delimited-text dump files. For information about reloading such dump ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlshow.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type ... The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/optimizing-innodb-storage-layout.html
For tables that are big, or contain lots of repetitive text or numeric data, consider using COMPRESSED row format. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html
(This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-summary-tables.html
Each error summary table has three columns that identify the error: ERROR_NUMBER is the numeric error value. The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). For a list of ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-host-cache-table.html
MySQL does not perform matching of Host column values in the mysql.user system table against host names for which one or more of the initial components of the name are entirely numeric, such as 1.2.example.com. The MySQL server maintains an ...