Practicing the SQLite, i know how to open the table, but I don't know how to open the same table after I close the program and enter again. Tomorrow I will look for a tutorial to see how to do it.
Today I was practicing the command (select * from "name of your table"). This command open what is inside your table named Actors (select * from Actors;) this command will show up names of some actors. But you have to create the table and then execute the command.
A database is made of a collection of tables (sometimes lots and *lots* of tables! ;-) In most other database systems, you have a server that runs on its own machine, and client applications that run on other machines and connect to the database. The whole thing can be pretty complicated.
ReplyDeleteSQLite is nice because it is much simpler, allowing us to focus on the ideas of how a database works without all the complexity. In SQLite, all the tables in a database are stored in a single file on the file system. You can use the CLI (command line interface) application, sqlite3 to open the database, create and drop tables, insert records, and make queries (using the select statement).