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/ansi-diff-update.html
If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. The ...
https://dev.mysql.com/doc/refman/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at https://dev.mysql.com/doc/. We try to keep the manual up to date by updating ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
The address configured with this option, if any, can be seen in the Master_Bind column of the output from SHOW SLAVE STATUS. If you are using a table for the source metadata repository (server started with master_info_repository=TABLE), the value ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Parameters in the message template are replaced with values that apply to a specific error occurrence: Identifiers such as table or column names use UTF-8 internally so they are copied as is. This section describes how the MySQL server uses ...
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
FULLTEXT indexes cannot be created on a column that uses any of these character sets. However, you can perform IN BOOLEAN MODE searches on the column without an index. Identifiers are stored in mysql database tables (user, db, and so forth) using ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MySQL requires that foreign key columns be indexed; if you create a table with a foreign key constraint but no index on a given column, an index is created. You can obtain information about foreign keys from the Information Schema KEY_COLUMN_USAGE ... Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all VARCHAR to CHAR with ALTER TABLE. Each MySQL version is tested on many platforms before it ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
The options that you specify are used to populate the columns in the mysql.servers table. The table columns are Server_name, Host, Db, Username, Password, Port and Socket. CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option ...