Comment 1 for bug 832679

Revision history for this message
Anton (anton-sidorov) wrote :

The query affected:

DROP TEMPORARY TABLE IF EXISTS TMP_VIEW;
DROP TABLE IF EXISTS VIEW;
CREATE TEMPORARY TABLE TMP_VIEW (
            learn_primary_key INT(20),
            evaluation_status_date DATETIME
) TYPE = InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;

CREATE TABLE VIEW (
            learn_primary_key INT(20),
            evaluation_status_date DATETIME
) TYPE = InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;

LOCK TABLES VIEW WRITE;

DELETE FROM VIEW;
INSERT INTO VIEW SELECT * FROM TMP_VIEW;

UNLOCK TABLES;