Creating Databases and Tables using SQLite3

Question

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.

See this question: stackoverflow.com/questions/5180895/…

borrrden
– borrrden

2012-03-31 06:17:42 +00:00
Commented Mar 31, 2012 at 6:17 — borrrden
– borrrden, Commented Mar 31, 2012 at 6:17

rakeshNS · Accepted Answer · 2012-03-31 06:21:20Z

3

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.

answered Mar 31, 2012 at 6:21

rakeshNS

4,2575 gold badges30 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abdullah Md. Zubair · Accepted Answer · 2012-03-31 06:19:20Z

3

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

answered Mar 31, 2012 at 6:19

Abdullah Md. Zubair

3,3242 gold badges32 silver badges39 bronze badges

Collectives™ on Stack Overflow

Creating Databases and Tables using SQLite3

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related