CREATE TABLE `events`.`speaker` ( `id` INT NOT NULL AUTO_INCREMENT COMMENT 'Stores all speakers', `name` VARCHAR(100) NOT NULL, `contactnumber` VARCHAR(15) NOT NULL, `rate` FLOAT NOT NULL, PRIMARY KEY (`id`)) COMMENT = 'speaker - name, contact number and rate';
DDL – table creation with auto increment primary key