Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
863 B
4
Indexable
Never
CREATE TABLE person (
    Id INT,
    firstname VARCHAR(20),
    lastname VARCHAR(20)
);

INSERT INTO person (Id,firstname, lastname)
VALUES 
    (1, 'John', 'Dev', 25),
    (2, 'John', 'carter', 30);

CREATE TABLE address (
    Id INT,
    street INT,
    city VARCHAR(20),
    state VARCHAR(20),
    pincode INT,
    country VARCHAR(20)	
);

INSERT INTO address
(Id,street,city,state,pincode,country)
VALUES 
    (1, 101, 'Pune','MAH',411052,'IND'),
    (2,102,'Bangalore','KAR',123456,'IND');



CREATE TABLE Phonenumber (
    Id INT,
    phonenumber INT
);

INSERT INTO phonenumber (Id,phonenumber)
VALUES 
    (1, 9845612851),
    (2,78945625685);

CREATE TABLE Email (
    Id INT,
    email VARCHAR(30)
);

INSERT INTO Email (Id,email)
VALUES 
    (1, 'johndev@gmail.com'),
    (2,'johncarter@gmail.com');


Leave a Comment