• Online Training

    Online Training

    SQL - Data Manipulation language commands



    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.

    Post a Comment