I was practicing SQLite commands from the (.help) this is a command on SQLite that hell you with the commands. Some commands that I practiced are 
.schema "table name"(this will told you what the table have in)
Example: schema cars (cars is the  name of my table ).
I get this message CREATE TABLE Cars(Id integer PRIMARY KEY, Name text, Cost integer);
.mode line "then the (select * from  'name of the table')", and you  will get something like this;
Id = 1
 Name = Angela
 Cost = 21
   Id = 2
 Name = Mercedes
 Cost = 57127
   Id = 3
 Name = Skoda
 Cost = 9000
   Id = 4
 Name = Volvo
 Cost = 29000
   Id = 5
 Name = Bentley
 Cost = 350000
   Id = 6
 Name = Citroen
 Cost = 21000
   Id = 7
 Name = Hummer
 Cost = 41400
   Id = 8
 Name = Volkswagen
 Cost = 21600
this will varies depending on what is in your table and what is about it.
I will try to learn more commands this week.
 
Excellent work!
ReplyDelete