https://dev.mysql.com/c-api-multiple-queries.html
By default, mysql_query() and mysql_real_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...MySQL also supports the execution of a string containing multiple statements separated by semicolon (;) ...
https://dev.mysql.com/cache-index.html
After the indexes have been assigned, they can be preloaded into the cache if desired with LOAD INDEX INTO CACHE. For more information, see Section 13.7.8.5, “LOAD INDEX INTO CACHE Statement”. | tbl_name PARTITION (partition_list) } IN ...
https://dev.mysql.com/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/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/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 characters in the Unicode range U+0000 to U+007F.
https://dev.mysql.com/comments.html
The KEY_BLOCK_SIZE keyword in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The comment syntax just described applies to how the mysqld server parses ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/create-procedure.html
See Section 9.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 ...To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create ...
https://dev.mysql.com/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 16.8, “The FEDERATED Storage Engine”. CREATE SERVER server_name ...
https://dev.mysql.com/create-table-ndb-table-comment-options.html
PARTITION_BALANCE is the preferred interface for setting the number of partitions per table. In MySQL NDB Cluster, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE option, which consists of one ...
https://dev.mysql.com/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 ...
