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;
The query affected:
DROP TEMPORARY TABLE IF EXISTS TMP_VIEW;
learn_ primary_ key INT(20),
evaluation _status_ date DATETIME
DROP TABLE IF EXISTS VIEW;
CREATE TEMPORARY TABLE TMP_VIEW (
) 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;