PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --defaults-extra-file Command-Line Format --defaults-extra-file=path Type String Default Value [none] Read given ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
group_replication_force_members Command-Line Format --group-replication-force-members=value Introduced 5.7.17 System Variable group_replication_force_members Scope Global Dynamic Yes Type String A list of peer addresses as a comma separated list ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-string Command-Line Format --connect-string=connection_string Type String Default ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
In one case only, the account may be specified with the USER() function: ALTER USER USER() IDENTIFIED BY 'auth_string'; This syntax enables changing your own password without naming your account literally. The plugin name can be a quoted string ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
--core-file-size=size Command-Line Format --core-file-size=size Type String Command-Line Format --core-file-size=size Type String The size of the core file that mysqld should be able to create. --malloc-lib=[lib_name] Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
For example, a hexadecimal literal assigned to a user-defined variable is a binary string by default. The 0x notation is based on ODBC, for which hexadecimal strings are often used to supply values for BLOB columns. To convert a string or a number ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
However, quotation marks are necessary to specify a user_name string containing special characters (such as -), or a host_name string containing special characters or wildcard characters such as % (for example, 'test-user'@'%.com'). Quote user names ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
For example, this statement performs a comparison between the column x and the string literal 'Y': SELECT x FROM T WHERE x = 'Y'; If x and 'Y' have the same collation, there is no ambiguity about the collation to use for the comparison. For example, ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...