Hi @Willyjgolden,
Sorry for the confusion, the edit is done automatically whenever the student adds a screen link to their post. The purpose of the edit is to make it easier for students to find relevant topics for a specific mission or screen. For example:
https://community.dataquest.io/tag/192
https://community.dataquest.io/tag/192-1
# sqlite3> .tables
# sqlite3> .headers on
# sqlite3> .mode column
# sqlite3> SELECT
# ...> track_id,
# ...> name,
# ...> album_id
# ...> FROM track
# ...> WHERE album_id = 3;
# sqlite3> .help
# sqlite3> .shell clear
# sqlite3> .quit
The solution code of this screen cannot be copy-pasted. This is because it contains # sqlite3>
on each line. The #
character is a workaround for our terminal screens to work the way we intended it to be and is not part of the actual solution and sqlite3>
is a prompt you get automatically once you run
sqlite3
command.
So the solution code for this screen is designed for typing manually. In any case, if you wish to copy paste, then you can try this code:
sqlite3 chinook.db <<EOF
.tables
.headers on
.mode column
SELECT
track_id,
name,
album_id
FROM track
WHERE album_id = 3;
.help
.shell clear
.quit
EOF
Heredoc (<<EOF) is not a concept we have taught in our command line missions. You can read more about it here:
Let me know if you have any further questions about it.
Best,
Sahil