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
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
When unix_timestamp is a floating point number, the fractional seconds precision of the datetime is 6. This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
The sort is done by going through all rows according to the join type and storing the sort key and pointer to the row for all rows that match the WHERE clause. The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
For example: ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges Relevant data points include: size: The number of pages used within ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
Only mysql is supported as the scheme value at this point. To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
Instead, the table definition includes a connection string that points to the remote table. When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
At this point, the tables are locked and quiescent: The tables are in a transactionally consistent state on disk and you can copy the .ibd tablespace files along with the corresponding .cfg files to get a consistent snapshot of those tables. | ...