EVOLUTION-MANAGER

Edit File: alter_table_disable_keys_truncate.result

DROP TABLE IF EXISTS users; SET NAMES utf8; CREATE TABLE users ( first_name VARCHAR(32) NOT NULL, last_name VARCHAR(32) NOT NULL, KEY (first_name, last_name) ); INSERT INTO users VALUES("Taro", "Yamada"); INSERT INTO users VALUES("Hanako", "Tanaka"); INSERT INTO users VALUES("Joe", "Honda"); SELECT * FROM users; first_name last_name Taro Yamada Hanako Tanaka Joe Honda ALTER TABLE users DISABLE KEYS; TRUNCATE users; SELECT * FROM users; first_name last_name DROP TABLE users;