Data
Manipulation language commands:-
1.Insert: By
using this command we can insert the data into the databse objects
Syntax: insert
into student values (101, ‘Kalyan’, ‘12-jun-13’, ‘hyderabad’);
Syntax:
insert into student
values (&student_no,&student_name,&student_dob,&student_city);
Syntax: insert
into student (student_no,student_name) values (&student_number, ‘&student_name’);
2.Update: By
using this command we can modify the data which is present in the database
object.
Syntax: update
student set student_name= ’badri’ where student_id=23;
Syntax: update
employee set bonus=1000;
//it
will applicable to all employees in the db object.
Syntax: update employee set esal=esal+5000 where
eid=23;
//it
will applicable to only a particular employee whose eid is 23
3.Delete: By
using this command we can delete the data from the existing database objects
Syntax:
delete from
student where student_name=’rajesh’;
//it
will deletes the particular student details whose name is rajesh.
Note: The
data which is present inside the database objects is case-sensitive.
No comments:
Post a Comment