/* 007 - select AND WHERE */ -- syntax ,select column-name form table_name -- create column CREATE TABLE tOne( id INT NOT NULL UNIQUE, name VARCHAR(50) 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' ); -- enter the data 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"); -- select all column SELECT * FROM tOne; -- select id,name,phone FORM column SELECT id,name,phone FROM tOne; -- where clause (conditional base search) -- syntax SELECT columna name FROM table name WHERE column name = condition meet SELECT * FROM tOne WHERE gender = "F"; SELECT * FROM tOne WHERE age<20; SELECT * FROM tOne WHERE city != "Agra"; SELECT * FROM tOne WHERE city = "Agra"; SELECT Id, Student Name FROM tOne WHERE city <> "Agra";