PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/close.html
If not closed explicitly, a cursor is closed at the end of the BEGIN ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM tbl_name WHERE date_column IS NULL This is needed to get some ODBC applications to work because ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
If you specify a SET NULL action, make sure that you have not declared the columns in the child table as NOT NULL. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
Also, any TIMESTAMP not explicitly declared as NOT NULL permits NULL values. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, “supported” ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. You can also explicitly assign 0 to the column to generate sequence ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
To perform case-sensitive comparisons instead, you should declare your columns with the BINARY attribute or use the BINARY cast, which causes comparisons to be done using the underlying character code values rather than a lexical ordering. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html
In a DECIMAL column declaration, the precision and scale can be (and usually is) specified. The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
<collation name="latin1_fulltext_ci" id="1025"/> </charset> Declare the sort order for the collation in the latin1.xml file. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...