![]() ![]() Click "Run SQL." (Note: We are not making any changes to the database, just running a Select query.In the "Enter SQL" box, replace the default "SELECT * FROM tablename" with this script query.Now that your database is open, click on the "Execute SQL" tab in the right pane.If a popup comes up saying that it's taking a while, just say continue (your database may be large). In SQLite Manger, click the folder icon, find your copied database file, and click "Open." Though we will not be making any changes to the database, it's better to be safe than to mess up your database. Rather than querying the database directly, find the zotero.sqlite file on your machine (do a web search if you're unsure where your Firefox profile folder is stored on your particular operating system), and make a copy of it to another location (like your desktop). ![]() In the manager, you will need to open your Zotero database, which is located in your Firefox profile folder.Now, click on the "Tools" menu and select "SQLite Manager.".Do a quick internet search to find it or go to "Tools > Add-ons" and search there. ![]()
0 Comments
Leave a Reply. |