Just like that, you have created a new database. Also, note that it is vital that you put. db after your desired database name to create a database file. We named the database Tweet_Data.db since I will be using tweets to populate the tables in the database. With the database now created, we can proceed to create our table of tweets. This is done by setting SQLite to csv mode using the. mode dot command followed by csv, and with the. import dot command that takes a file (in this case a csv located in the same folder, but it can be any csv in your computer if you type the full path) and a table name of your choice.
You may also want to display the column headers using the. Once you have done this, you can use the. tables command to display all the available tables in a database file as well as the. schema command followed by a table name to display the table's structure. Furthermore, you can execute a simple query such as SELECT $$ FROM Table_Name* to verify that the data is there.
