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/stored-programs-defining.html
This statement may be a compound statement made up of several statements separated by semicolon (;) characters. The following example shows how to do this for the dorepeat() procedure just shown. This enables the ; delimiter used in the procedure ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
This has several implications: When the routine is invoked, an implicit USE db_name is performed (and undone when the routine terminates). This can be used to refer to a routine that is not in the current database. This means the client must use a ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. The recommended way to do this is to symlink entire database ... You ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
This section describes how the MySQL server and client programs respond to signals. This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). This ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form --maximum-var_name=value at server startup. The MySQL server maintains many system variables ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
This special treatment of NULL is why, in the previous section, it was necessary to determine which animals are no longer alive using death IS NOT NULL instead of death <> NULL. A common error when working with NULL is to assume that it is not ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
To work around this, drop the column, then add it with the new definition. This can lead to inconsistent data being returned and unexpectedly failed statements. For this reason, as of MySQL 5.7.13, ALTER TABLE operations that change the definition ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If something goes seriously wrong (although this shouldn't happen), MySQL may leave the old table as B-xxx. This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes originate) writes updates and changes as “events” to the binary ...The information in the binary log is stored in different logging formats according to the database changes being ...