PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile files. If you already created some InnoDB tables, also delete ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. GeometryCollection() with no arguments is permitted as a way to create an empty geometry. The functions described in this section are MySQL extensions to the OpenGIS ...
https://dev.mysql.com/doc/refman/5.7/en/making-windows-dumps.html
The PDB file contains more detailed information about mysqld and other tools that enables more detailed trace and dump files to be created. Program Database files (with suffix pdb) are included in the ZIP Archive Debug Binaries & Test Suite ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkb-functions.html
These functions also accept geometry objects as returned by the functions in Section 12.16.5, “MySQL-Specific Functions That Create Geometry Values”. These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation ...
https://dev.mysql.com/doc/refman/5.7/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. To do this, you must have a mysqld that has been compiled with debugging support. If the version number ends with -debug, it is ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). ST_GeomFromText() accepts a WKT value of any geometry type as its first argument. Other functions provide ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...
https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program. To associate MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ...An event is not migrated or dropped as a result of renaming or dropping the user who created ... To enable or disable the execution ...