PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. (See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have ...The restrictions for stored procedures also apply to the DO clause of Event Scheduler event ...Some of the restrictions ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
For example, before upgrading from MySQL 5.6 to 5.7, use mysqladmin from MySQL 5.6 as follows: C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, invoke mysqladmin with ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. Please see the corresponding item ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is latin1_swedish_ci, whereas lookups are case-sensitive if the collation is latin1_general_cs or ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...For example, MySQL automatically converts strings to numbers as necessary, and vice ... When an operator is used ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
For example, to set the variable to 16MB, start the server like this: $> mysqld --max_allowed_packet=16M You can also use an option file to set max_allowed_packet. For example, to set the size for the server to 16MB, add the following lines in an ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-backup.html
Along with --read-from-remote-server, it is common to specify other options: --host indicates where the server is running, and you may also need to specify connection options such as --user and --password. By default, mysqlbinlog reads binary log ...mysqlbinlog can read log files directly from the local file system, or, with the --read-from-remote-server option, it can connect to a server and request binary log contents from that ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/5.7/en/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom ...