#working on auto incremnet 
CREATE TABLE customer5(
    acc_n0 INT PRIMARY KEY AUTO_INCREMENT,   # no need to write again and again
    name VARCHAR(50) NOT NULL,
    acc_type VARCHAR(50) NOT NULL DEFAULT 'SAVINGS'
    );
DESC customer5;
INSERT INTO customer5 (name) VALUES ('RAJJJU');
INSERT INTO customer5 (name) VALUES ('RA');
INSERT INTO customer5 (name) VALUES ('l̥');
INSERT INTO customer5 (name) VALUES ('k');
INSERT INTO customer5 (name) VALUES ('j');
INSERT INTO customer5 (name) VALUES ('g');

INSERT INTO customer5 (acc_n0,name) VALUES (1001,'RAJJJU'); # we can change the values 
INSERT INTO customer5 (name) VALUES ('SID'); #1002
SELECT * FROM customer5;