PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/9.7/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...
https://dev.mysql.com/doc/refman/9.7/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...
https://dev.mysql.com/doc/refman/9.7/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/9.7/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-installation.html
Note The Audit Log component is intended to replace the Audit Log plugin, which is now deprecated. This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log component and related elements ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component.html
Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server component named audit_log. MySQL Enterprise Audit uses the ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log.html
Important The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you should expect the plugin to be removed in a future version of MySQL. For more information about the audit log ...