PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/charset-repertoire.html
String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode range U+0000 to U+007F. The ASCII range is a subset of UNICODE range, so a string ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-delete-all.html
Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. --connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] ...In some cases, this can be much faster than DELETE or even TRUNCATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. --connect-string Command-Line Format --connect-string=connection_string Type String Default ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
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/mysql-cluster-programs-ndb-mgm.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --defaults-extra-file Command-Line Format --defaults-extra-file=path Type String Default Value [none] Read given ...