PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...
https://dev.mysql.com/doc/refman/9.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-requirements.html
Review the following requirements and restrictions for table annotations and DML operations on JSON duality views. Requirements and Restrictions for Insert Annotations The root object and sub-objects of a document must have the INSERT annotation.
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-service.html
MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as ...
https://dev.mysql.com/doc/refman/9.7/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. MySQL sometimes optimizes a query that has a LIMIT row_count clause and no ...