CREATE TABLE test ( id MEDIUMINT NOT NULL AUTO_INCREMENT, message VARCHAR(255), PRIMARY KEY (id) ); INSERT INTO test (message) VALUES ('test 1'); INSERT INTO test (message) VALUES ('test 2'); INSERT INTO test (message) VALUES ('test 3'); INSERT INTO test (message) VALUES ('test 4');