PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/5.7/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); .
https://dev.mysql.com/doc/refman/5.7/en/compilation-problems.html
Normally, the build process does not need to create sql_yacc.cc because MySQL comes with a pregenerated copy. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE ... This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. If there are multiple INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
If this mode is enabled at the time that a table is created, TIMESTAMP columns are created as DATETIME columns. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an expression; it need not be a constant. If the DEFAULT clause ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
CRUD Operations Create, Read, Update and Delete (CRUD) operations are the four basic operations that can be performed on a database Collection or Table. In terms of MySQL this means: Create a new entry (insertion or addition) Read entries (queries) ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-troubleshooting.html
After downgrading, reload the dump file using mysql or mysqlimport to re-create your tables. Dump any tables that were inaccessible to the older server by using mysqldump to create a dump file. If you downgrade from one release series to another, ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. Note To upgrade the shared library associated with a loadable ... DROP ...