PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/call.html
C programs can use the prepared-statement interface to execute CALL statements and access OUT and INOUT parameters. Languages that provide a MySQL interface can use prepared CALL statements to directly retrieve OUT and INOUT procedure parameters.
https://dev.mysql.com/doc/refman/8.0/en/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. (The indentation used here in the ELSE clause is for purposes of clarity only, ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
Another variant of C-style comment syntax is used to specify optimizer hints. Hint comments include a + character following the /* comment opening sequence. If there is a concern that optimizer-hint comments may be stored in object definitions so ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
See Section 11.2.5, “Function Name Parsing and Resolution”, for the rules describing how the server interprets references to different kinds of functions. This enables the ; delimiter used in the procedure body to be passed through to the server ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
The data stored in the table can be used when creating a connection to a FEDERATED table: CREATE TABLE t (s1 INT) ENGINE=FEDERATED CONNECTION='s'; For more information, see Section 18.8, “The FEDERATED Storage Engine”. CREATE SERVER server_name ...
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/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine stores data in text files using ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
For example, use the smaller integer types if possible to get smaller tables. MEDIUMINT is often a better choice than INT because a MEDIUMINT column uses 25% less space. You can hint that you want to have fixed length rows even if you have VARCHAR ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
For example, in contexts where MySQL expects a date, it interprets any of '2015-07-21', '20150721', and 20150721 as a date. For example, '20070523' and '070523' are interpreted as '2007-05-23', but '071332' is illegal (it has nonsensical month and ... Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...