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/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Connector/NET enables developers to create .NET applications that connect to MySQL. MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to MySQL resources using either the classic MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
You should try to create a reproducible test case that demonstrates the problem. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
The same restrictions apply to internal temporary tables created to hold the result set for a cursor as for other uses of internal temporary tables. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
.isl files: InnoDB Symbolic Link files containing the location of file-per-table tablespace files created outside of the data directory. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-limitations.html
Manual creation of database directories under the data directory (for example, with mkdir) is unsupported. Manually created database directories are not recognized by the MySQL Server. This section describes temporary limitations introduced with ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
Data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, which resides in the MySQL data directory. The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are located in ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the ...