Create a table ‘Customer’ with
- cust_id,
- cust_name,
- dob, city, street, state, pincode ,
- ph_no, deal_no,
- photo_identity, v_id
and insert values into it.
SET SCHEMA 'STUDENT';
CREATE TABLE CUSTOMER(
cust_id INTEGER,
cust_name VARCHAR,
dob VARCHAR,
city VARCHAR,
street VARCHAR,
state VARCHAR,
pincode INTEGER,
ph_no VARCHAR,
deal_no INTEGER,
photo_identity VARCHAR,
v_id INTEGER
);
INSERT INTO CUSTOMER (cust_id,cust_name,dob,city,street,state, pincode , ph_no,deal_no,photo_identity,v_id)
VALUES(41,'raju',13-09-1996,'Guntur','Ramgopal street','Andhra Pradesh',500213,'9123456789',10,'y',3);