Home » MYSQL » Update Query » Question
  1. In the following query how many rows will be updated?
    UPDATE person
    SET Lname=’Gupta’,
    Fname=’Ajit’,
    WHERE person_id < 10;
    /* person_id is a primary key */
    1. 1-6
    2. No row
    3. 0-9
    4. All of above
    5. None of these
Correct Option: C

0-9



Your comments will be displayed only after manual approval.