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/storage-requirements.html
While a NULL itself does not require any storage space, NDB reserves 4 bytes per row if the table definition contains any columns defined as NULL, up to 32 NULL columns. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
Attempting to use REORGANIZE PARTITION without the partition_names INTO (partition_definitions) option on explicitly partitioned tables results in the error REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
It makes SQL operations faster, by enabling better use of indexes and eliminating overhead for testing whether each value is NULL. If you really need NULL values in your tables, use them. Just avoid the default setting that allows NULL values in ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
row *************************** Id: 1 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: show processlist *************************** 2. row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format. There are also functions to convert a string from WKT or WKB format to internal geometry format. See Section ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
The query is invalid if name is not a primary key of t or a unique NOT NULL column. SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
This can have values A (ascending), D (descending), or NULL (not sorted). That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. NULLABLE Contains YES if the column may contain NULL ...