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/charset-applications.html
The examples shown here assume use of the utf8 character set and utf8_general_ci collation in particular contexts as an alternative to the defaults of latin1 and latin1_swedish_ci. To create a database such that its tables use a given default ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
Section 23.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the event table ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Alternatively, you can use ON (or 1) or OFF (or 0) in place of the DISABLED value when starting the server. Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The server manipulates the mysql.proc table in response to statements that create, alter, or drop stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. If the automatic_sp_privileges system variable is 0, the ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server and whether connections are encrypted. Command Options for Connection Establishment Command Options for ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. Note Alternative means for performing the process described in this section: On Windows, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
Proceed to checking the table-level replication options, if there are any. For a description of how these options are checked, see Section 16.2.5.2, “Evaluation of Table-Level Replication Options”. The statement is not executed until all ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. This value may be updated by ALTER EVENT to ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
https://dev.mysql.com/doc/refman/5.7/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system database. Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, ...This database and the access control system are discussed extensively in Chapter 5, MySQL Server Administration, which you should consult for additional ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...