Q. Find out the logical error in the following MySQL code snippet?
CREATE TABLE person
( person_id VARCHAR(20),
Name VARCHAR (20),
Address VARCHAR (20),
Mobile_no SMALLINT
);
CREATE TABLE person
( person_id VARCHAR(20),
Name VARCHAR (20),
Address VARCHAR (20),
Mobile_no SMALLINT
);
β
Correct Answer: (C)
Primary key is missing
Explanation: This code snippet is trying to create a table named "person" with four columns: