-- create a table
create table customers1(
    id INT NOT NULL,
   -- name VARCHAR(199) NOT NULL,
    address VARCHAR(50) DEFAULT 'SONIMANDIR'
    );

#DESC  #describe
INSERT INTO customers1(id) VALUES (101); # throw error -- Field 'name' doesn't have a default value
SELECT * FROM customers1;

create table customers2(
    id INT NOT NULL,
    name VARCHAR(50) NOT NULL,
    acc_type VARCHAR(50) NOT NULL DEFAULT 'savings'  #value given in default value 
    );
#SELECT * FROM customers2;

#DESC customers2;
INSERT INTO customers2(id,name) VALUES (101,'RAJU'),(102,'ISD'),(103,'PAUL');
#SELECT * FROM customers2;


#default value change by update method
UPDATE customers2 SET acc_type = "CURRENT" WHERE NAME= "ISD";
#SELECT * FROM customers2;