• CREATE TABLE `test`.`roombook` ( `roomid` VARCHAR(45) NOT NULL, `roomtype` VARCHAR(45)

NULL, `charges` INT NULL, `cust` VARCHAR(45) NULL, `mob` VARCHAR(45) NULL, `statusroom`

VARCHAR(45) NULL, PRIMARY KEY (`roomid`));

• insert into roombook values('1001','Delux',5000,'','','Not Booked’) ;

• insert into roombook values('1002','Super Delux',7000,'','','Not Booked’) ;

• insert into roombook values('1003','Suit',9500,'','','Not Booked') ;

• insert into roombook values('2001','Delux',5000,'','','Not Booked’);

• insert into roombook values('2002','Super Delux',7000,'','','Not Booked’) ;

• insert into roombook values('2003','Suit',9500,'','','Not Booked’) ;