Insert Records into Guest table in SQL

Interview, RDBMS / , ,

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
Quiz for Exam - Insert Records into Guest table

Code:

sample.sql

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);

Recommended:

Leave a Comment

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

x