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/stored-objects.html
The following sections provide additional information about SQL syntax for statements related to these objects, and about object processing: For each object type, there are CREATE, ALTER, and DROP statements that control which objects exist and how ... This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
Similarly, any changes to existing stored routines or triggers must be carried out explicitly on all Cluster SQL nodes, using the appropriate ALTER or DROP statements on each MySQL Server accessing the cluster. Some of the restrictions noted here ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the proc table exists. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
The existing character sets provide the best documentation and examples to show how these functions are implemented. For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
This is useful primarily when you must be compliant with old applications that depend on the existence of a column but that do not actually use its value. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
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/sys-execute-prepared-stmt.html
If that statement name exists when the procedure is called, its previous content is destroyed. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). This enables you to alter the configuration temporarily for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.