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/string-functions-charset.html
As of MySQL 5.7.19, an exception to the preceding principle occurs for expressions for virtual generated columns. MySQL has many operators and functions that return a string. This section answers the question: What is the character set and ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. The Commercial Edition provides additional Enterprise features, such as database ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
The filter is useful to log statements that update or delete anything from the temp_1 or temp_2 tables, such as this one: UPDATE temp_1, temp_3 SET temp_1.a=21, temp_3.a=23; The statement generates multiple table_access events, but the audit log ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
For SQL output (CREATE and INSERT statements), local or remote dumps can be done and generate output on the client. This section describes the characteristics of different types of backups. Physical (Raw) Versus Logical Backups Physical backups ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...