PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
When using a CONNECTION string, you cannot use an '@' character in the password. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
The argument to AGAINST() must be a string value that is constant during query evaluation. For example, for an INSERT operation, an inserted string is tokenized and decomposed into individual words. Full-text searches are supported for InnoDB and ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
The sizes of the identifier string columns in the grant tables are measured in characters. Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
MySQL uses the default collation for this character set (utf8_general_ci) for all searches, sorts, comparisons, and other string operations on such columns. Because some MySQL objects are represented as files, searches in INFORMATION_SCHEMA string ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT INTO pet VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL); String and date values are specified as ...Suppose that your pet records can be described as shown ...
https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html
For example, the following statements all assess to TRUE: mysql> SELECT 10 IS TRUE; -> 1 mysql> SELECT -10 IS TRUE; -> 1 mysql> SELECT 'string' IS NOT NULL; -> 1 NOT, ! Logical NOT. Table 12.5 Logical Operators Name Description AND, && Logical AND ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
While a statement is running, a copy of the current statement string is also allocated. MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups. For example, the mysqlcheck program reads the [mysqlcheck] and ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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: ...