PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
Displaying 311 to 317
of 317 total results
- « Previous
- 30
- 31
- 32
https://dev.mysql.com/doc/refman/8.0/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: Visible: YES Expression: NULL ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html
This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
The index contains unique values to eliminate duplicates and make the table smaller. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a ...
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
Also take into account that the MyISAM storage engine needs two file descriptors for each unique open table. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
Trigger names exist in the schema namespace, meaning that all triggers must have unique names within a schema. To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
You set up rules governing the relationships between different data fields, such as one-to-one, one-to-many, unique, required or optional, and “pointers” between different tables. MySQL, the most popular Open Source SQL database management ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
A table that is used with a WHERE clause on a PRIMARY KEY or a UNIQUE index, where all index parts are compared to constant expressions and are defined as NOT NULL. This section discusses optimizations that can be made for processing WHERE clauses.