Hi, I am new on learning SQL and everything went well till “Go Off Platform” section.
I followed the instruction of setting SQLite but I am stuck. After cd to the folder where sqlite at in my computer, when I typed “winpty ./sqlite3.exe”, it showed nothing but money sign instead of “sqlite>”. I did try following the instruction of the video tutorial, which is different with the text one, and it returns nothing, not even a “$”.
I tried both methods several times and it went through once (not even know how and which one made it through). The “acs-1-year-2005.sqlite” was opened successfully and I was able to select * and got table. However, it reached the bottom of screen and everything I typed won’t appear anymore. I didn’t know how to clear screen that time so I just closed Git and reopened it. Then everything stuck now, I cannot open any databases, I cannot get “sqlite>” no matter the text or video instruction I applied. Lots of time my typing went invisible after "“winpty ./sqlite3.exe” command.
I don’t know how to proceed the course and it’s very disappointed that I have to stop at this way instead of having understanding issue. Please can anyone helps me on this, I really enjoy learning SQL.
Btw, it’s annoyed that the text and tutorial instructions using different software with different commands and contents. It’s very confusing.