Grants for @localhost                |
 GRANT USAGE ON *.* TO ''@'localhost'
CREATE DATABASE details;
USE details;
/*CREATE TABLE STUDENT(
ROLL_NO INT,
NAME VARCHAR(50),
CLASS CHAR(5),
SEM INT,
ADVISER INT );
CREATE TABLE FACULTY(
FID int,
NAME VARCHAR(50),
SALARY INT,
DEPT VARCHAR(5));



ALTER TABLE STUDENT
ADD PRIMARY KEY(ROLL_NO);
ALTER TABLE FACULTY
ADD primary key(FID);
ALTER TABLE STUDENT
ADD FOREIGN KEY(ADVISER) references FACULTY(FID); -- don't know if delete cascade or update cascade should be used
INSERT INTO STUDENT(ROLL_NO,NAME,CLASS,SEM,ADVISER)
values (1,'susan','CSB',4,101),
       (2,'jacob','csb',4,101);
INSERT INTO FACULTY(FID,NAME,SALARY,DEPT)
VALUES(101,'jerrin',89000,'cs'),
       (102,'arun',89700,'cs');
       select * from faculty;
DELETE FROM FACULTY 
WHERE dept = 'cs';
SELECT *FROM FACULTY;*/