PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER VIEW is permitted only to the definer or users with the SUPER privilege. ALTER [ALGORITHM = ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
This is the user name that the server uses for privilege checking, and may differ from the <USER> value. This is the user name that the server uses for privilege checking, and it may differ from the USER value. This is the user name that the server ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Changing the session binlog_format value requires privileges sufficient to set restricted session system variables. You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for ...
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/dbug-package.html
This variable has global and session values: mysql> SET GLOBAL debug = 'debug_options'; mysql> SET SESSION debug = 'debug_options'; Changing the global debug value requires privileges sufficient to set global system variables. Changing the session ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
USING table_references [WHERE where_condition] Privileges You need the DELETE privilege on a table to delete rows from it. You need only the SELECT privilege for any columns that are only read, such as those named in the WHERE clause. DELETE is a ...
https://dev.mysql.com/doc/refman/5.7/en/differences-from-ansi.html
We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between the MySQL and standard SQL privilege systems. For example, in ...The CAST() function does not support cast to REAL or ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
For the reasons for this, see Section 13.2.5.3, “INSERT DELAYED Statement”, Inserting into a table requires the INSERT privilege for the table. If the ON DUPLICATE KEY UPDATE clause is used and a duplicate key causes an UPDATE to be performed ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
On the other hand, you do not need the FILE privilege, and the file can be located in any directory the client program can access. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
In such cases, the server returns ER_HOST_NOT_PRIVILEGED and does not even ask for a user name or password. COUNT_PROXY_USER_ACL_ERRORS The number of errors detected when proxy user A is proxied to another user B who does exist but for whom A does ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...