Find the error?CREATE TABLE Employee( Employee

Home » MYSQL » Mysql Query Optimization » Question

Find the error?

CREATE TABLE Employee
( Employee_id SMALLINT, name VARCHAR, LAST VARCHAR
  CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));
  INSERT INTO Employee
  VALUES( Employee_id, name, LAST)
  (1, ’s’, ’p’);
  INSERT INTO person
  ( Employee_id, name, LAST)
  VALUES(1,’s’,’p’);

1. Error, Duplicate value
2. Any other error
3. No error
4. All of above
5. None of these

Correct Option: A

Primary can never have same value.