-- create a table
CREATE TABLE customer (
customerID INT PRIMARY KEY,
customername VARCHAR(20) NOT NULL,
customerMobile VARCHAR(11) NOT NULL,
customerCategory CHAR);
DESC customer;
INSERT INTO customer VALUES
(001,'ARMAN','REDMI','Y'),
(002,'AVOI','REALME','Y'),
(003,'ANUSHKA','VIVO','X'),
(004,'ANANTA','OPPO','X'),
(005,'ARMIN','iPHONE','Z');
SELECT * FROM customer;