Today I basically went over the tutorial again and now I know how to check all the tables I did by typing command ".tables" and it shows all the tables I have created.
There is another command called " .separator : " and what it does is to separate columns, but it get in the right columns u got to type ".mode column" & ".headers on" then you select the file name of the table and it appears right there.
I showed you how to put these commands in your .sqliterc file, so that they will run every time you start sqlite3.
ReplyDelete