2
# Simple test of the transaction log for testing ALTER command
6
DROP TABLE IF EXISTS t1;
11
, padding VARCHAR(200) NOT NULL
15
INSERT INTO t1 VALUES (1, "I love testing.");
16
INSERT INTO t1 VALUES (2, "I hate testing.");
18
# Simple addition of a new column
19
ALTER TABLE t1 ADD dummy INT;
21
# Add an index via ALTER TABLE
22
ALTER TABLE t1 ADD INDEX ix_padding (padding(20));