-- create a table
CREATE TABLE customer(
    acc_no INT PRIMARY KEY,
    name VARCHAR(40) NOT NULL,
    acc_type VARCHAR(50) NOT NULL DEFAULT 'SAVINGS'
    );
#DESC customer;
INSERT INTO customer(acc_no,name,acc_type) VALUES (101,"SIDDHARTH", "CURRENT");
INSERT INTO customer(acc_no,name) VALUES (102,"SIDDHARTH"); #(acc_no,name) IF YOU ARE MENTIONED HERE ANYTHING THEN INSIDE THE VALUES THIS ALL TO BE PRESENT
#ID==101 -- DUPILCATE WARNINGS
#INSERT INTO customer(name) VALUES ('Paul');  # as acc_no cannot be null
#INSERT INTO customer(acc_no,name) VALUES (NULL,"aug"); #Column 'acc_no' cannot be null
SELECT * FROM customer;