Home » MYSQL » Create Tables » Question
  1. Will this query produce any error?
    INSERT INTO Employee
    (Emp_id, fname,lname)
    VALUES (101,’Sujit’,’Gupta’),
    VALUES (101,’Ajit’,’Gupta’);
    /* where person_id is a primary key */
    1. Depends
    2. Error
    3. No Error
    4. All of above
    5. None of these
Correct Option: B

Emp_id declared as a primary key therefore it never contain same value.



Your comments will be displayed only after manual approval.