PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
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 corrupted tables if any of the following events occur: The mysqld process is killed ...You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same ...
https://dev.mysql.com/doc/refman/5.7/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/5.7/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. Cursor declarations must appear before handler declarations and after ...The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
To provide a default value for a variable, include a DEFAULT clause. Permissible characters and quoting rules are the same as for other identifiers, as described in Section 9.2, “Schema Object Names”. For examples of variable declarations, see ...type [DEFAULT value] This statement declares local variables within stored ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-shell-install.html
This section describes how to download, install, and start MySQL Shell, which is an interactive JavaScript, Python, or SQL interface supporting development and administration for the MySQL Server. Requirements MySQL Shell is available on Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function.html
The DROP FUNCTION statement is used to drop stored functions and loadable functions: For information about dropping stored functions, see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”. For information about dropping loadable ...
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 13.7.3.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. DROP FUNCTION is also used to drop ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 13.6.5.1, “CASE Statement”, for use inside ...If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement. Many of these constructs ...