sqlite startup

[ameliabob 3]

I have been a user of SQL and am now trying to start up a private database using sqlite.

There does not appear to be a corresponding tool like phpmyadmin that I can find.

How can I display columns and contents.  There is a reference to ./tables and ./columns.  but I cannot find what these a part of.

Are the usages the same whether I am using the python shell or the command line?

That should get me started.

Thanks

[justsomeguy 1,093]

If I go to Google and type "sqlite", the first suggestion is "browser".  It looks like there is a SQLite browser project to browse database structures and data.

[niche 129]

You also can use python to display the results from your queries.