Today I took my time trying to understand how to create a table using sqlite, so I try some examples I copy and paste the examples showed in the tutorial and it work, little by little I understood how it works, I learned how to select or view the table created, example " select * from Actors,Movies or whatever the table is called."
Now the only problem I had was after creating tables and I exit sqlite I do not know how to save the tables I did, so when I opened sqlite again and try to open the tables I created it did not show because I did not save it. I guess I got to read more and find the command to save what I do in sqlite.
The problem, as you now know, was that you were only using a temporary database. You need to specify a database file when you start SQLite if you want your data to persist.
ReplyDelete