PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
This is NULL if the column has an explicit default of NULL, or if the column definition includes no DEFAULT clause. The value is YES if NULL values can be stored in the column, NO if not. (A UNIQUE index permits multiple NULL values, but you can ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=path Type String Default Value [none] The directory where character sets are installed. --debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
For example, inserting the string '1999.0e-2' into an INT, FLOAT, DECIMAL(10,6), or YEAR column inserts the value 1999, 19.9921, 19.992100, or 1999, respectively. The value stored in the INT and YEAR columns is 1999 because the string-to-number ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID Collation: A Cardinality: 4188 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: *************************** 2. row ... 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/partitioning.html
See Section 24.3.16, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, see Section 22.2.7, “How MySQL Partitioning Handles NULL”. Note As of MySQL 5.7.17, the generic ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/5.7/en/getting-information.html
To find out which database is currently selected, use the DATABASE() function: mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | menagerie | +------------+ If you have not yet selected any database, the result is NULL. What ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
If the event's timing is determined by an EVERY clause instead of an AT clause (that is, if the event is recurring), the value of this column is NULL. This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the ... The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. This condition does not apply if the WITHOUT VALIDATION ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.21.3, “Expression Handling”, and Section 12.21.4, “Rounding Behavior”. Consider the ...