πŸ“Š MySQL
Q. Find the error in the following SQL statement?
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE
CONSTRAINTS pk_person PRIMARY KEY (person_id));
INSERT INTO person
VALUES( person_id, name, LAST, Birth_date)
(1,’s’,’p’, 24-1991-01);
  • (A) In correct data value
  • (B) No error
  • (C) Any other error
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (A) In correct data value

Explanation: This SQL code has a few errors. Let's break them down:

Explanation by: Bhagwan Das
This SQL code has a few errors. Let's break them down:

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
68
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Bhagwan Das
Publisher
πŸ“ˆ
94%
Success Rate