PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
Exception: For string literals that have an introducer such as _utf8mb4 or _latin2, the introducer determines the character set. For comparisons of strings with column values, collation_connection does not matter because columns have their own ... A ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In this case, the statement displays output only for the columns with names matching the string. There is no need to enclose the string within quotation marks unless it contains spaces or other special characters. In practice, the DESCRIBE keyword ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
If any of the operands of a +, -, /, *, % is a real or string value, the precision of the result is the precision of the operand with the maximum precision. (See Section 11.1, “Numeric Data Types”.) / Division: mysql> SELECT 3/5; -> 0.60 ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” In some cases, this is more convenient than using NULL values, ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
The mecab_rc_file option is not recognized by MySQL until the MeCaB parser plugin is installed but it must be set before attempting to install the MeCaB parser plugin. The built-in MySQL full-text parser uses the white space between words as a ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
The available referential actions are RESTRICT (the default), CASCADE, SET NULL, and NO ACTION. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.