Insert Records into Guest table in SQL

Question:

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”:[]}]}

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 database program | relational database management system software |  rdbms lab programs | rdbms lab programs pdf |  dbms programs | database management software | database management system software |  examples of database software| list of database applications | database system applications | examples of database | application database application software | database management application

best dbms software |  software that is used to create | manipulate and maintain a relational database | database management system application

Tags:- rdbms programs with output | rdbms programs pdf  | dbms programs examples | rdbms lab programs | rdbms lab programs pdf | rdbms practical programs | rdbms practical programs pdf | rdbms sample programs | rdbms program | rdbms system| rdbms lab programs madras university | rdbms online programs | rdbms lab programs with output | rdbms procedure program | rdbms sql programs | codechef | google | 2021

Previous
Next Post »