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/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
mysql_upgrade returns an error if a sys schema exists but has no version view, on the assumption that absence of this view indicates a user-created sys schema. Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). FULLTEXT indexes cannot be created on a column that uses any of these character ...The ucs2, utf16, utf16le, and utf32 character sets have the following restrictions: None of them can be used as the client character ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
(Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style comments. MySQL Server supports three comment styles: From a # character to the end of ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an ...
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Connector/NET enables developers to create .NET applications that connect to MySQL. Native drivers are also easier for end users to build and deploy because no copy of the MySQL client libraries is needed to build the native driver components.
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
ddl_log.log is not created until it is actually needed for recording metadata statements, and is removed following a successful start of mysqld. There are no user-configurable server options or variables associated with this file. The DDL log, or ...