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/copying-databases.html
After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. In cases where you need to transfer databases between different architectures, you can use mysqldump ...
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
The most important thing to know is whether the table became corrupted as a result of an unexpected server exit. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
Important Under some circumstances, CREATE USER may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information.
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
For example: $> mysql -h host -u user -p menagerie Enter password: ******** Important menagerie in the command just shown is not your password. If the administrator creates your database for you when setting up your permissions, you can begin using ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
If a string return value should be in a different character set, convert it. The following example shows how to convert the result of gen_rnd_email() to the utf8mb4 character set: SET @email = CONVERT(gen_rnd_email() USING utf8mb4); It may also be ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
If speed is more important than disk space and the maintenance costs of keeping multiple copies of data, for example in a business intelligence scenario where you analyze all the data from large tables, you can relax the normalization rules, ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Important The mysql.session user must exist before you can load X Plugin. To use MySQL 5.7 as a document store, the X Plugin needs to be installed. Then you can use X Protocol to communicate with the server. Without the X Plugin running, X Protocol ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
Important MySQL Shell 8.0 is the most recent version and is highly recommended for use with MySQL Server 5.7. This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your ...