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

Leave a Reply

Your email address will not be published. Required fields are marked *