00001 # 00002 # Simple test of the transaction log for testing ALTER command 00003 # 00004 --disable_warnings 00005 DROP TABLE IF EXISTS t1; 00006 --enable_warnings 00007 00008 CREATE TABLE t1 ( 00009 id INT NOT NULL 00010 , padding VARCHAR(200) NOT NULL 00011 , PRIMARY KEY (id) 00012 ); 00013 00014 INSERT INTO t1 VALUES (1, "I love testing."); 00015 INSERT INTO t1 VALUES (2, "I hate testing."); 00016 00017 # Simple addition of a new column 00018 ALTER TABLE t1 ADD dummy INT; 00019 00020 # Add an index via ALTER TABLE 00021 ALTER TABLE t1 ADD INDEX ix_padding (padding(20)); 00022 00023 DROP TABLE t1; 00024