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/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses. The ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-rolling-restart.html
Create a backup using the ndb_mgm client START BACKUP command prior to performing the restart. Use mysqldump to create a backup prior to the upgrade; afterward, restore the dump using LOAD DATA. This also applies to any MySQL Server version change ... This section discusses how to perform a rolling restart of an NDB Cluster installation, so called because it involves stopping and starting (or restarting) each node in turn, so that the cluster itself remains ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to ...
https://dev.mysql.com/doc/refman/5.7/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. (That privilege is granted automatically to the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. By default, that privilege is granted ... ALTER ...
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 ...