Insert Records into Guest table in SQL

Question:

Insert Records into Guest table

Insert the following records into “Guest” table based on schema given below

GUESTID NAME ADDRESS COUNTRY EMAIL PHONE
1234 RAJ GUPTA 116 LAKE ROAD O
OOTACAMUND
INDIA RAJ@HOTMAIL.COM 919090909090
1235 JACK MARTIN NO:5ST ANTONYS CHRUCH CHENNAI INDIA JACK.1909@GMAIL.COM 917867867834
1236 MARY GREY 14/2 EAST GHAT ROAD KODAIKANAL INDIA MARK.KOM@GMAIL.COM 911234565432
{“type”:”inserter”,”blocks”:[{“clientId”:”4fc41852-6286-40c0-a0b0-45788352e328″,”name”:”core/image”,”isValid”:true,”attributes”:{“alt”:””},”innerBlocks”:[]}]}
Resort management system 1

CODE:

insert into Guest values(1234, 'RAJ GUPTA', '116 LAKE ROAD OOTACAMUND', 'INDIA', 'RAJ@HOTMAIL.COM', 919090909090);
insert into Guest values(1235, 'JACK MARTIN', 'NO:5ST ANTONYS CHRUCH CHENNAI', 'INDIA', 'JACK.1909@GMAIL.COM', 917867867834);
insert into Guest values(1236, 'MARY GREY', '14/2 EAST GHAT ROAD KODAIKANAL', 'INDIA', 'MARK.KOM@GYAHOO.COM', 911234565432);

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program

Leave a Comment