CREATE TABLE example_table ( tran_id INT NOT NULL AUTO_INCREMENT , item VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( tran_id ) )