Advertisement
Guest User

Untitled

a guest
Mar 30th, 2020
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. CREATE TABLE student (
  2. ID INT NOT NULL,
  3. NAME VARCHAR (50) NOT NULL,
  4. PRIMARY KEY (ID)
  5. );
  6.  
  7. CREATE TABLE country (
  8. ID INT NOT NULL,
  9. COUNTRYNAME VARCHAR (50) NOT NULL,
  10. PRIMARY KEY (ID)
  11. );
  12.  
  13. INSERT INTO Student VALUES ('1','HARSH');
  14. INSERT INTO Student VALUES ('2','RAMESH');
  15. INSERT INTO Student VALUES ('3','SURESH');
  16. INSERT INTO Student VALUES ('4','MAHESH');
  17. INSERT INTO Student VALUES ('5','RAJESH');
  18.  
  19. INSERT INTO COUNTRY VALUES ('1','India');
  20. INSERT INTO COUNTRY VALUES ('2','Aus');
  21. INSERT INTO COUNTRY VALUES ('3','Canada');
  22. INSERT INTO COUNTRY VALUES ('4','India');
  23. INSERT INTO COUNTRY VALUES ('5','Aus');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement