CREATE TABLE `testUnique`( username VARCHAR(20) UNIQUE KEY, email VARCHAR(50) UNIQUE, id SMALLINT(8) ZEROFILL )ENGINE=InnoDB CHARSET =UTF8;