Search

Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 255.8Kb
Man Pages (Zip) - 360.7Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb


Displaying 21 to 30 of 996 total results
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. Use the CREATE TABLE statement to create a table ...See also the notes about spatial indexes under Section 11.4.9, “Creating Spatial ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/5.7/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group.html
SELECT article, MAX(price) AS price FROM shop GROUP BY article ORDER BY article; +---------+-------+ | article | price | +---------+-------+ | 0001 | 3.99 | | 0002 | 10.99 | | 0003 | 1.69 | | 0004 | 19.95 | +---------+-------+ .
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column.html
“What is the highest item number?” SELECT MAX(article) AS article FROM shop; +---------+ | article | +---------+ | 4 | +---------+ .
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
digest_type indicates the digest algorithm used to generate the digest string. digest_type indicates the digest algorithm used to generate the digest string. It corresponds to the private key passed to asymmetric_sign() to generate the signature ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. All tables that are to be combined must have identical structure (same column names and types, same indexes, and so forth). empty-space The ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
When using internal_tmp_disk_storage_engine=INNODB (the default), queries that generate on-disk internal temporary tables that exceed InnoDB row or column limits return Row size too large or Too many columns errors. auto_generate_certs Command-Line ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
The --innodb-status-file option is intended for temporary use, as SHOW ENGINE INNODB STATUS output generation can affect performance, and the innodb_status.pid file can become quite large over time. innodb_autoinc_lock_mode Command-Line Format ...
Displaying 21 to 30 of 996 total results