PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. See Section 15.7.6.2, “SET CHARACTER SET Statement”, and Section 15.7.6.3, “SET NAMES Statement”.
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as ...
https://dev.mysql.com/doc/refman/8.0/en/show-variables.html
Strictly speaking, because _ is a wildcard that matches any single character, you should escape it as \_ to match it literally. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
The parameter values can contain unescaped SQL quote and delimiter characters. SQL syntax for prepared statements does not support multi-statements (that is, multiple statements within a single string separated by ; characters). Using prepared ...
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
Strictly speaking, because _ is a wildcard that matches any single character, you should escape it as \_ to match it literally. The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
Aliases for column names in CREATE VIEW statements are checked against the maximum column length of 64 characters (not the maximum alias length of 256 characters). As a result, views created from the output of SHOW CREATE VIEW fail if any column ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
gtrid and bqual must be string literals, each up to 64 bytes (not characters) long. However, while an SQL statement containing an XA statement is being parsed, the server works with some specific character set. To perform XA transactions in MySQL, ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
If the host name contains a '%' or '_' pattern character or uses netmask notation, the account can be used for clients connecting from multiple hosts and the CURRENT_USER() value does not indicate which one. Specifically, do not permit User to be ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the ...