Learn SQL by Building a Student Database: Part 1 - Build a Student Database: Part 1

Backend Development
1

Tell us what’s happening:
Describe your issue in detail here.

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36

Challenge: Learn SQL by Building a Student Database: Part 1 - Build a Student Database: Part 1

Link to the challenge:

1 Like
2

Hi there and welcome to the forum!

Did you have a question about this project? If you could explain the issue in your own words, it would help us to help you!

3

I’m running this script in the terminal:
codeally@798325f2ef03:~/project$ cat courses.csv | while read MAJOR COURSE; do echo $MAJOR; done
and when I run it, the terminal reads from the csv file in mention, but when I hit the button RUN, it appears the following message:
Your script should have the suggested command added correctly
and I have checked that code thousands of times and all is correct, that’s what I wanna believe.
I hope you can help me on this, since I’ve been stuck for almost a whole night yesterday and part of today lol

4

You’ve checked the hints and verified that the command you’re running is exactly the same as the one in the hints?

If so, sometimes the CodeRoad container gets out of sync and can cause this problem to arise, but hitting the Reset button often fixes this.

Failing that, a soft reset from the Project Options menu is also worth a try.

1 Like
5

hi, and thanks for your help.
I’ve done it repeatedly and doesn’t work.
I put in the console:
cat course.csv | while read MAJOR COURSE
do
echo $MAJOR
done

and keeps stating the same error message

6

This is the result I see when running the code in the project terminal:
codeally@0ec793ac4945:~/project$ cat courses.csv | while read MAJOR COURSE

do
echo $MAJOR
done
major,course
Database
Web
Database
Data
Network
Database
Data
Network
Computer
Database
Game
Data
Computer
System
Game
Web
Data
Web
Game
System
Game
System
System
Computer
Computer
Network
Web
Network
and when hitting the run button, I get the same error message.

7

hi,
Nothing seems to work, I have clicked the soft reset button thousands of times and stuck yet.
I have follow indentation, Un-indentantion and nothing. got frustrated

8

I can’t remember the steps for this course but are you sure you should be entering this code directly into the terminal and not into your .sh file?