/* 019 UPDATE */ -- create table CREATE TABLE tOne( id INT NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, percentage INT NOT NULL, age INT NOT NULL CHECK(age >= 18), gender VARCHAR(1) NOT NULL, phone VARCHAR(10) NOT NULL UNIQUE, city VARCHAR(15) NOT NULL DEFAULT 'Agra' ); -- insert records -- INSERT INTO tOne(id,name,age,gender,phone,city) VALUES (1,"Ram Kumar","23","M","4022155","Agra"), (2,"Sarita Kumari","21","F","4034421","Delhi"), (3,"Salman Khan","20","M","4056221","Agra"), (4,"Juhi Chawla","28","F","4022156","Bhopal"), (5,"Anil Kapoor","22","M","4025221","Agra"), (6,"John Abraham","21","M","4056776","Delhi"), (7,"Shahid Kapoor","20","M","4022784","Agra"); UPDATE tOne SET phone = "4055555" WHERE id = 1; -- update phoen whre id = 1 UPDATE tOne SET age = 66 WHERE id = 2; UPDATE tOne SET age = 55 WHERE id IN (2,4); -- select id 2 and 4 only UPDATE tOne SET age = 19; -- cant chage the whole table value in safe mode