PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.
https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China (PRC). Unassigned ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
MYSQL_USER, MYSQL_PASSWORD: These variables are used in conjunction to create a user and set that user's password, and the user is granted superuser permissions for the database specified by the MYSQL_DATABASE variable. MYSQL_RANDOM_ROOT_PASSWORD: ...In the following example, we run the mysql client from inside the myapp1 container to connect to host mysql1 in its own container: docker exec -it myapp1 mysql --host=mysql1 --user=myuser --password For other networking techniques for containers, see the Docker container networking section in the Docker ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
Notes Character set information is also available from the SHOW CHARACTER SET statement. The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE CHARACTER_SET_NAME LIKE 'wild'] SHOW CHARACTER SET [LIKE 'wild'] ...The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read ...To kill threads belonging to other users, the connected user must have the SUPER ...You can use it to check ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors occur. For example, whenever the ...One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> elements. If the sorting rules for your language are too complex to be handled with simple arrays, ...The existing character sets provide the best documentation and examples to show how these functions are ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
For a column defined as SET('a','b','c'), values such as 'd' or 'a,b,c,d' are invalid and are rejected. For SET, the value is inserted as given except that any invalid substrings are deleted. ENUM and SET columns provide an efficient way to define ...The value cannot be the error value (that is, 0 or the empty ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
Note that if a value of 0 was set previously for the server ID, you must restart the server to initialize the source with your new nonzero server ID. Note The following options have an impact on this procedure: For the greatest possible durability ...You can change the server_id value dynamically by issuing a statement like this: SET GLOBAL server_id = 2; With the default server ID of 0, a source refuses any connections from replicas, and a replica refuses to connect to a source, so this value cannot be used in a replication ...