PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html
You can report any discrepancies that you encounter to the MySQL bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. See Previous NDB Cluster Issues Resolved in NDB Cluster 8.0 for a list of issues in ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
The information in the binary log is stored in different logging formats according to the database changes being recorded. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL ...
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 ...