PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-update.html
The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. UPDATE t1 SET col1 = col1 + 1, col2 = col1; . If you access a column from the table to be updated in an expression, UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/constraints.html
Individual clients can set the SQL mode at runtime, which enables each client to select the behavior most appropriate for its requirements. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which ... MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
If explicit_defaults_for_timestamp is disabled, the server handles TIMESTAMP as follows: Unless specified otherwise, the first TIMESTAMP column in a table is defined to be automatically set to the date and time of the most recent modification if not ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...To define a column that includes a fractional seconds part, use the ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 9.1.3, “Date and Time Literals”. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-windows.html
If the server writes the error log to the console, it sets the log_error system variable to stderr. Otherwise, the server writes the error log to a file and sets log_error to the file name. In addition, the server by default writes events and error ... On Windows, mysqld uses the --log-error, --pid-file, and --console options to determine whether mysqld writes the error log to the console or a file, and, if to a file, the file name: If --console is given, mysqld writes the error log to the ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multipolygon.html
A MultiPolygon has no two Polygon elements that cross (crossing is also forbidden by the previous assertion), or that touch at an infinite number of points. A MultiPolygon boundary is a set of closed curves (LineString values) corresponding to the ... A MultiPolygon is a MultiSurface object composed of Polygon ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-polygon.html
Polygon Examples On a region map, Polygon objects could represent forests, districts, and so on. Polygon Assertions The boundary of a Polygon consists of a set of LinearRing objects (that is, LineString objects that are both simple and closed) that ... A Polygon is a planar Surface representing a multisided ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
For example: mysql> SET @mp = 'MULTIPOINT(1 1, 2 2, 3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@mp)); +---------------------------------+ | ST_AsText(ST_GeomFromText(@mp)) | +---------------------------------+ | MULTIPOINT((1 1),(2 2),(3 3)) | ... MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB ...See Section 12.16.3, ...