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

GUESTIDNAMEADDRESSCOUNTRYEMAILPHONE
1234RAJ GUPTA116 LAKE ROAD O
OOTACAMUND
INDIARAJ@HOTMAIL.COM919090909090
1235JACK MARTINNO:5ST ANTONYS CHRUCH CHENNAIINDIAJACK.1909@GMAIL.COM917867867834
1236MARY GREY14/2 EAST GHAT ROAD KODAIKANALINDIAMARK.KOM@GMAIL.COM911234565432
{“type”:”inserter”,”blocks”:[{“clientId”:”4fc41852-6286-40c0-a0b0-45788352e328″,”name”:”core/image”,”isValid”:true,”attributes”:{“alt”:””},”innerBlocks”:[]}]}
Insert Records into Guest table in SQL

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

Sharing Is Caring

Leave a Comment