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/mysql-cluster-replication-conflict-resolution.html
NDB applies WRITE_ROW events strictly as inserts, requiring that there is not already any such row; that is, an incoming write is always rejected if the row already exists. For NDB$MAX_DELETE_WIN(), if the “timestamp” column value for a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. For example, if a table for a text file does not exist, continue processing any remaining files. The ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 13.1.18, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
mysql> SELECT COALESCE(NULL,1); -> 1 mysql> SELECT COALESCE(NULL,NULL,NULL); -> NULL EXISTS(query) Whether the result of a query contains any rows. Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
If any tables named in the argument list do not exist, DROP TABLE behavior depends on whether the IF EXISTS clause is given: Without IF EXISTS, the statement drops all named tables that do exist, and returns an error indicating which nonexisting ...
https://dev.mysql.com/doc/refman/5.7/en/drop-view.html
If any views named in the argument list do not exist, the statement returns an error indicating by name which nonexisting views it was unable to drop, but also drops all views in the list that do exist. Note In MySQL 8.0, DROP VIEW fails if any ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
ALTER USER may be used to change the nonprivilege characteristics of existing accounts. Note If an account named in a GRANT statement does not already exist, GRANT may create it under the conditions described later in the discussion of the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
If the log says that the table already exists inside the InnoDB internal data dictionary, you have an orphan table inside the InnoDB tablespace files that has no corresponding .frm file. The error message looks like this: InnoDB: Error: table ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
INSERT with an ON DUPLICATE KEY UPDATE clause enables existing rows to be updated if a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY. (This is not necessarily the number of rows actually inserted because ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
mysql_install_db creates the data directory, which must not already exist: If the data directory does already exist, you are performing an upgrade operation (not an install operation) and should run mysql_upgrade, not mysql_install_db. If the data ... Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL ...