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/srjs-data-arguments.html
String: The CHAR, VARCHAR, TEXT, and BLOB string types are supported. Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data types. The data types are listed here: Integer: All variants and ...
https://dev.mysql.com/doc/refman/9.7/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is ...Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to ...
https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html
This differs from comparisons performed with the = operator, for which the significance of trailing spaces in nonbinary strings (CHAR, VARCHAR, and TEXT values) depends on the pad attribute of the collation used for the comparison. For example, ...
https://dev.mysql.com/doc/refman/9.7/en/sys-create-synonym-db.html
Parameters in_db_name VARCHAR(64): The name of the schema for which to create the synonym. 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 ...
https://dev.mysql.com/doc/refman/9.7/en/sys-extract-schema-from-file-name.html
Parameters path VARCHAR(512): The full path to a data file from which to extract the schema name. 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/9.7/en/sys-extract-table-from-file-name.html
Parameters path VARCHAR(512): The full path to a data file from which to extract the table name. Given a file path name, returns the path component that represents the table name. This function is useful when extracting file I/O information from ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-is-account-enabled.html
Parameters in_host VARCHAR(60): The host name of the account to check. Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...
https://dev.mysql.com/doc/refman/9.7/en/sys-table-exists.html
Parameters in_db VARCHAR(64): The name of the database in which to check for table existence. in_table VARCHAR(64): The name of the table to check the existence of. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...