Search

Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 255.8Kb
Man Pages (Zip) - 360.8Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb


Displaying 681 to 690 of 1425 total results
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...Cast Function and Operator Descriptions Character Set Conversions Character Set Conversions for String Comparisons Other Uses for Cast Operations Cast Function and Operator Descriptions BINARY expr The BINARY operator converts the expression to a binary string (a string that has the binary character set and binary ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
The maximum number of indexes per table and the maximum index length is defined per storage engine. All storage engines support at least 16 indexes per table and a total index length of at least 256 bytes. For example: CREATE TABLE test (blob_col ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MySQL ...The available referential actions are RESTRICT (the default), CASCADE, SET NULL, and NO ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
The CREATE SERVER statement creates a new row in the servers table in the mysql database. The CREATE SERVER statement creates an entry in the mysql.servers table that can later be used with the CREATE TABLE statement when creating a FEDERATED table.
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
It enables authentication, SSL/TLS, resource-limit, and password-management properties to be established for new accounts, and controls whether accounts are initially locked or unlocked. Plugin names are stored in the plugin column of the mysql.user ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
The allowlist is the set of rules that defines which statements are acceptable to the profile. For example: the profile can be placed in training mode to establish the allowlist; the allowlist can be used for restricting statement execution or ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese are provided for use with ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
Creating a FULLTEXT Index that Uses the ngram Parser To create a FULLTEXT index that uses the ngram parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. The following example demonstrates creating a table with an ngram ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as identifiers. The identifier quote character is the backtick (`): mysql> SELECT * FROM ...Section 9.2.1, “Identifier Length Limits”, indicates the maximum length of each type of ...
Displaying 681 to 690 of 1425 total results