I still haven't used sqlite to directly venture into the database and look at the tables, maybe play with them a little bit.
Though I would like to do that, i can't seem to find a way. This has to be something trivial, but it still is a roadblock.
I got into the sqlite shell by entering sqlite in the terminal but couldn't find my way after that. I tried putting commands like .databases and SELECT * FROM Table but didn't find any success.
At one point even getting out of the shell seemed impossible with me trying exit, exit(), quit, quit(), .quit and 3 more permutations of the above, all in vain. At the end, pressing ; somehow got me out. Ah! ; is needed to end SQL commands, so the commands should go here. But I needed to move to more pressing issues by then and I decided to leave sqlite experimentation to some other day.
No comments:
Post a Comment