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/show-events.html
It requires the EVENT privilege for the database from which the events are to be shown. row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. This is because of the following: Stored routine definitions are kept in tables in the mysql system database using the MyISAM storage engine, and so do ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
A stored procedure or function is associated with a particular database. This can be used to refer to a routine that is not in the current database. For example, to invoke a stored procedure p or function f that is associated with the test database, ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Other database systems might use little-endian byte order or a BOM. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode Standard ...
https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
Unsuccessful connection attempts can occur for the following reasons: A client attempts to access a database but has no privileges for it. If connection problems occur such as communication errors or aborted connections, use these sources of ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Among other instructions discussed there, it is especially important to back up your database before the upgrade. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
Before downgrading to a previous version, it is recommended that you drop the sys schema: DROP DATABASE sys; If you are downgrading to a release that includes the sys schema, mysql_upgrade recreates the sys schema in a compatible form. The effect ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking is not a replacement for the table definition cache, and its mutexes and locks differ from the LOCK_open mutex. Metadata ...