EPUB | CHM | PDF

TMySQLDump.Properties.DisableUniqueChecks

Top Previous Next

note Since v2.7.0

Generates SQL statements to disable uniqueness checks for secondary indexes in InnoDB tables.

Syntax:

property DisableUniqueChecks: Boolean default True;

Description:

Set DisableUniqueChecks property value to True to generate the following SQL statements.

In dump script header:

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

In dump script footer:

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

tip Take a look at MySQL Manual for additional details.