MYSQL,RDBMS
things which make thing easy Ex. creating table in mysql CREATE TABLE student( student_id INT, name VARCHAR(20) NOT NULL, subject VARCHAR(20) /////DEFAULT 'undefined'///UNIQUE/////AUTO INCREMENT, PRIMARY KEY(student_id)///important to mention ); /////inserting data///// SELECT * from student; INSERT INTO student VALUES(1,'rahul','math'); INSERT INTO student VALUES(2,'aaditya','English'); INSERT INTO student VALUES(3,NULL,'biology');//error --->name should not be null INSERT INTO student(student_id,name) VALUES(4,'rajesh');--->for specific use '*' this symbol is used to select all the data from database Ex. select * from student; for specific use Ex. select major, name from student order by name/////name desc;////asc (ascending) not equal----> '< >' Projection is unary operator it is used to list it returns arguments which are specific to it • It yields a v...