DBMS LAB
Experiment -3
Part- 1
Create table student with attributes
rollno,sname,branch,dob.
Insert data into the table.
Add new attribute address to student table.
Update table by modifying address as hyderabad.
Update address
of student as delhi whose name is rahul.
Update address of student as Calcutta whose rollno is 111 and name is sharat.
Update address of student as chennai whose branch is
cse or name is bharat
Update name and rollno of student as raghu and
101 who is staying at Chennai.
Delete details of student whose rollno is 111.
Delete details of student whose name is navya and
rollno is 222.
Delete all details of student table.
Part-2
Practice TCL commands.
Part-3
Practice all predefined functions.
LIKE
column value is similar to specified character(s).
IN
column value is equal to any one of a specified set of values.
BETWEEN...AND
column value is between two values, including the end values
specified in the range.
IS NULL
column value does not exist