CODEWITHSUNDEEP
sqlite
Illep
Illep

Reputation: 16859

Creating Databases and Tables using SQLite3

I have used SQLIte3 to create databases and then added tables to it. Then i closed the terminal and reopened it.

I typed the command sqlite3, and typed select * from tableName; It says the table is not found.

Think i have to select the database first and then type the above select statement to work. So how can i do that ?

SQL commands like show databases; is not recognized.

Upvotes: 2

Views: 2446

Answers (2)

rakeshNS
rakeshNS

Reputation: 4257

You have to write sqlite3 DB_NAME on terminal to open database. Then you can see sqlite prompt like sqlite3> You can enter command select * from tableName there, so that your tables will be listed. You can also try .schema command to see the schema of your data base. Refer the site http://www.sqlite.org/ for more details.

Upvotes: 3

Abdullah Md. Zubair
Abdullah Md. Zubair

Reputation: 3324

You can use SQLite Manager firefox add-on to view sqlite database, table and execute query there.

Upvotes: 3

Related Questions