PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/bug-reports.html
If you work with Windows, you can usually get the name and version number by double-clicking your My Computer icon and pulling down the “Help/About Windows” menu. Before posting a bug report about a problem, please try to verify that it is a ...
https://dev.mysql.com/doc/refman/9.7/en/choosing-types.html
If accuracy is not too important or if speed is the highest priority, the DOUBLE type may be good enough. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the ...
https://dev.mysql.com/doc/refman/9.7/en/comments.html
In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab. MySQL Server supports three comment styles: From a # character to the end of the line.
https://dev.mysql.com/doc/refman/9.7/en/cost-model.html
Making Changes to the Cost Model Database For DBAs who wish to change the cost model parameters from their defaults, try doubling or halving the value and measuring the effect. To generate execution plans, the optimizer uses a cost model that is ...
https://dev.mysql.com/doc/refman/9.7/en/create-library.html
The code string can be dollar-quoted or single-quoted; it can also be double-quoted as long as ANSI_QUOTES SQL mode is not set. CREATE LIBRARY [IF NOT EXISTS] [database.]library LANGUAGE language [COMMENT "comment_text"] AS code This statement ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
Alternatively, double quotation marks (") can be used if the ANSI_QUOTES SQL mode is enabled. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
The file_name, including any specified path, must be quoted with single or double quotation marks. The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine.
https://dev.mysql.com/doc/refman/9.7/en/data-masking-policy-usage.html
Dynamic data masking enables you to conditionally mask column data for specific users or roles. A masking policy is a rule, or set of rules, which determines how a column's data is transformed for access control. A masking policy consists of the ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a ...
https://dev.mysql.com/doc/refman/9.7/en/encryption-functions.html
If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a ...