document-3.txt

CREATE TABLE STUDENT(
   STUDENT_ID INT PRIMARY KEY AUTO_INCREMENT,
   STUDENT_NAME VARCHAR(30) NOT NULL,
   MAJOR VARCHAR(30) DEFAULT 'UNDECIDED'
);

SELECT * FROM STUDENT;

DROP TABLE STUDENT;

INSERT INTO STUDENT VALUES(1,'PRAJYOT','INFORMATION TECHNOLOGY');
INSERT INTO STUDENT VALUES(2,'YASH','MECHANICAL ENGINEERING');
INSERT INTO STUDENT VALUES(3,'MRUDAL','COMPUTER SCIENCE');
INSERT INTO STUDENT VALUES(4,'AMAN','INFORMATION TECHNOLOGY');
INSERT INTO STUDENT VALUES(5,'SAURABH','COMPUTER SCIENCE');
INSERT INTO STUDENT(STUDENT_ID,STUDENT_NAME) VALUES(1,'PRAJYOT');
INSERT INTO STUDENT(STUDENT_NAME,MAJOR) VALUES('YSH','COMPUTER SCIENCE');
INSERT INTO STUDENT(STUDENT_NAME,MAJOR) VALUES('ABHAY','COMPUTER SCIENCE');


UPDATE STUDENT 
SET MAJOR='SOCIAL SCIENCE'
WHERE STUDENT_ID=1;

UPDATE STUDENT
SET MAJOR ='SOCIAL SCIENCE'
WHERE MAJOR = 'INFORMATION TECHNOLOGY' OR MAJOR ='COMPUTER SCIENCE';

DELETE FROM STUDENT
WHERE STUDENT_ID=5;

DELETE FROM STUDENT
WHERE STUDENT_NAME=PRAJYOT AND MAJOR='INFORMATIO TECHNOLGY'

THIS IS ROW IS ONLY GONE BE DELETED IF BOTH THE CONDITION IS GET SATISFIED