Scribd
Upload
6 views1 page

Country and City Database Entries

The document contains SQL insert statements for populating three tables: COUNTRY_MASTER, CITIES_MASTER, and STATE_MASTER. It adds countries such as India, USA, and South Africa, along with their respective states and cities. The data includes specific IDs and names for each entry in the tables.

Uploaded by

MD HOZAIFA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views1 page

Country and City Database Entries

The document contains SQL insert statements for populating three tables: COUNTRY_MASTER, CITIES_MASTER, and STATE_MASTER. It adds countries such as India, USA, and South Africa, along with their respective states and cities. The data includes specific IDs and names for each entry in the tables.

Uploaded by

MD HOZAIFA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Insert into COUNTRY_MASTER (COUNTRY_ID ,COUNTRY_NAME) VALUES(1,"INDIA");

Insert into COUNTRY_MASTER (COUNTRY_ID ,COUNTRY_NAME) VALUES(2,"USA");


Insert into COUNTRY_MASTER (COUNTRY_ID ,COUNTRY_NAME) VALUES(3,"SOUTH AFRICA");

INSERT INTO CITIES_MASTER (CITY_ID ,CITY_NAME,STATE_ID) VALUES(1,"DBG",1);

INSERT INTO CITIES_MASTER (CITY_ID ,CITY_NAME,STATE_ID) VALUES(2,"MFZ",1);

INSERT INTO CITIES_MASTER (CITY_ID ,CITY_NAME,STATE_ID) VALUES(3,"SMP",1);

INSERT INTO CITIES_MASTER (CITY_ID ,CITY_NAME,STATE_ID) VALUES(4,"KTH",2);

INSERT INTO CITIES_MASTER (CITY_ID ,CITY_NAME,STATE_ID) VALUES(5,"LKT",3);

INSERT INTO STATE_MASTER (STATE_ID,COUNTRY_ID ,STATE_NAME) VALUES(1,1,"BIHAR");


INSERT INTO STATE_MASTER (STATE_ID,COUNTRY_ID ,STATE_NAME) VALUES(2,1,"LUCKNOW");
INSERT INTO STATE_MASTER (STATE_ID,COUNTRY_ID ,STATE_NAME) VALUES(3,1,"ANDH
PRADESH");

You might also like