Tell us what’s happening:
Course: Learn SQL by Building a Student Database: Part 1
It only needs the name of a major. The ID will be added automatically. Add the first major from the courses.csv
file into the majors
table. It’s a VARCHAR
, so make sure to put the value in single quotes.
-
The major is
Database Administration
-
Use the
INSERT INTO
andVALUES
keywords -
Here’s an example:
INSERT INTO <table_name>(<column_name>) VALUES(<value>);
-
Type
INSERT INTO majors(major) VALUES('Database Administration');
Doing that doen’t proceed in course.
Your code so far
INSERT INTO majors(major) VALUES(‘Database Administration’);
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0
Challenge Information:
Learn SQL by Building a Student Database: Part 1 - Build a Student Database: Part 1