PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/sys-extract-schema-from-file-name.html
It provides a convenient way to display schema names, which can be more easily understood than full path names, and can be used in joins against object schema names. Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies within the schema ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-table-from-file-name.html
It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names. Given a file path name, returns the path component that represents the table name.
https://dev.mysql.com/doc/refman/8.0/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/8.0/en/sys-list-drop.html
Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified.
https://dev.mysql.com/doc/refman/8.0/en/sys-session-ssl-status.html
For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions. The session_ssl_status view has these columns: thread_id The thread ID for the connection.
https://dev.mysql.com/doc/refman/8.0/en/sys-table-exists.html
If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.0/en/updating-sles-repo.html
On the SUSE Linux Enterprise Server (SLES) platform, to perform an in-place upgrade of MySQL and its components, use the MySQL SLES repository. See Upgrading MySQL with the MySQL SLES Repository in A Quick Guide to Using the MySQL SLES Repository.
https://dev.mysql.com/doc/refman/8.0/en/use.html
The following example accesses the author table from the db1 database and the editor table from the db2 database: USE db1; SELECT author_name,editor_name FROM author,db2.editor WHERE author.editor_id = db2.editor.editor_id; . USE db_name The USE ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...