Find The Error In The Following Sql Statementp Pre Langsql #463

Find the error in the following SQL statement?</p> <pre><code class="language-sql"> CREATE TABLE person ( person_id SMALLINT, name varchar, last varchar CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, last) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, last) VALUES(1,’s’,’p’); </code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs113 MySQL. It can also be found in gs gs113 Query Optimization - When Good Statements Go Bad - Quiz No.1.

 CREATE TABLE person ( person_id SMALLINT, name varchar, last varchar CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, last) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, last) VALUES(1,’s’,’p’);