- Create a Table
StudentInfo
Create table StudentInfo(
StudentID varchar(10) NOT NULL,
FirstName varchar(20),
LastName varchar(20),
SSN int,
DateofBirth DATE,
PRIMARY KEY (StudentID)
);
- Create a Table
‘ClassInfo’
  Create table
ClassInfo(
ClassID varchar(10) NOT NULL,
ClassName varchar(4),
ClassDescription varchar(20),
PRIMARY KEY ( ClassID)
);
- Create a table ‘RegisteredClasses’​​​​​​​
Create table RegisteredClasses(
FOREIGN KEY (StudentID) REFERENCES Persons(StudentID),
FOREIGN KEY (ClassID) REFERENCES Persons(ClassID)
);
- Query to show all records from StudentInfo whose first
name is John
Select * from StudentInfo
where FirstName=\"John\"
- Query to show all records from StudentInfo whose last
name is Doe
Select * from StudentInfo
where FirstName=\"Doe\"
- Query to delete all records from from ClassInfo where
class name starts with ‘ISAM'
Delete from ClassInfo
WHERE (ClassName REGEXP '^ISAM')
