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/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
If X Plugin is enabled, it exposes several system variables that permit control over its operation: mysqlx_bind_address Command-Line Format --mysqlx-bind-address=addr System Variable mysqlx_bind_address Scope Global Dynamic No Type String Default ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Each of those functions, if successful, returns a binary string indicating what action occurred. The SUPER privilege is required to call any of the Version Token functions, so token list modification is expected to be done by a management or ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
Thus, stored functions and triggers cannot use dynamic SQL (where you construct statements as strings and then execute them). Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions.
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
With PIPES_AS_CONCAT enabled, || is string concatenation, with a precedence between ^ and the unary operators. expr is treated as a string, so be careful if you specify a nonstring value with INTERVAL. This section lists the grammar rules that ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The procs_priv table applies to stored routines (stored procedures and functions). A privilege granted at the routine level applies only to a single procedure or function. Table 6.5 procs_priv Table Columns Table Name procs_priv Scope columns Host ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
These may invoke administrative functions, so stored procedure access also requires the privileges needed for those functions. Grant the SUPER privilege so that the firewall administrative functions can be executed. Warning Setting the ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
For example, the C API provides a set of function calls that make up its prepared statement API. For example, you cannot use the mysql_stmt_prepare() C API function to prepare a PREPARE, EXECUTE, or DEALLOCATE PREPARE statement. SQL syntax for ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
You can always store an exact integer value in a BIGINT column by storing it using a string. In this case, MySQL performs a string-to-number conversion that involves no intermediate double-precision representation. This means that if you multiply ...