Apple SequelPro-MySQL client Tool

Software name: SequelPro (MySQL client tool) official website address: www.sequelpro.com this tool will generate a bad SQL statement when exporting table data :*! 40000ALTERTABLE 'sbtest' DISABL

Software name: SequelPro (MySQL client tool) official website address: http://www.sequelpro.com/when this tool is used to export table data, it will contain an awkward SQL :/*! 40000ALTERTABLE 'sbtest' DISABL

Software name: Sequel Pro (MySQL client tool)
Official website address:

When exporting table data, this tool generates a bad SQL statement:

/*! 40000 alter table 'sbtest' disable keys */;

This SQL statement is used for batch insert of MyISAM engine. To speed up the insert, the ALTER TABLE t1 DISABLE KEYS; statement is added to DISABLE the index. There is a certain risk because after the insert is complete, execute alter table t1 enable keys; to ENABLE the index. Enabling the index here is equivalent to rebuilding the index, which is time-consuming and locks the TABLE. This function should be disabled.

Because the InnoDB engine uses memory-Type Buffer writes, It is designed differently from the MyISAM engine and is not affected.

The following is a test:

This article is from the "hechun's technical column" blog. Be sure to keep this source