ameliabob 3 Report post Posted July 11, 2018 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 Share this post Link to post Share on other sites
justsomeguy 1,093 Report post Posted July 11, 2018 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. Share this post Link to post Share on other sites
niche 129 Report post Posted July 11, 2018 You also can use python to display the results from your queries. Share this post Link to post Share on other sites