/* 021 - DELETE */ -- create table -- safe mode go to Edit -> Preferences -> SQL Editor, > "Safe Updates" > (reconnect MySQL server ) > Query -> Reconnect to Server. 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,percentage,age,gender,phone,city) VALUES (1,"Ram Kumar","45","23","M","4022155","Agra"), (2,"Sarita Kumari","56","21","F","4034421","Delhi"), (3,"Salman Khan","62","20","M","4056221","Agra"), (4,"Juhi Chawla","47","18","F","4020055","Bhopal"), (5,"Anil Kapoor","74","22","M","4025221","Agra"), (6,"John Abraham","64","21","M","4056776","Delhi"), (7,"Shahid Kapoor","52","20","M","4022784","Agra"); DELETE FROM tOne WHERE id = 4; DELETE FROM tOne WHERE gender = 'F'; -- can not delete you are using a safe mode DELETE FROM tOne WHERE age > 20; -- can not delete you are using a safe mode DELETE FROM tOne; -- delete the entir database, but not the databasse name