Geek Answers Handbook

How to save in SQLite Manager?

I opened the sqlite3 database file in firefox sqlite manager, making some changes to it, but I don’t see a way to save it?

There are various export options such as CSV, SQL, and XML.

I am new to this and just updating someone else's work.

+4
source share
3 answers

This is a database. The result of the data affecting the queries is saved as executed in the database, for example:

  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • INSERT
  • UDPATE
  • DELETE
+1
source

If you use the data grid editor, then as soon as the UPDATE query is started, the changes to ALREADY are committed to the database.

If you use an SQL scope and type your own UPDATE or DELETE : SQLite uses a single statement transaction by default; You can manually start and complete the transaction using BEGIN; and END; or COMMIT; .

So, if you ran an UPDATE or DELETE , it was committed, and you cannot roll back.

0
source

10/06/15 this page is no longer., Http://code.google.com/p/sqlite-manager/wiki/ExecuteSQL

Save [and delete] Query by name

SELECT Queries and other SQL statements can be stored in the SQLite database and re-run later from the Execute SQL SQLite Manager tab.

To enable this function, go to the "Tools" menu in the menu bar and check the "Use table for internal data" item.

To save the SQL statement, click the "Save Query" icon on the "Execute SQL" tab, in which you will be asked to enter a query name.

To receive an SQL query, select it by name from the drop-down menu under the Enter SQL text box.

The text of the instruction will be written in the Enter SQL text box, where it can be changed, if necessary, before starting.

To remove a saved query from the menu, run the following SQL query containing the query name in the Enter SQL text box.

 DELETE FROM __sm_ext_mgmt WHERE type = "NamedQuery: query_name"

I do not understand this syntax. Maybe I'm not getting into the right place. None of this worked. I tried to run them as a request:

Syntax:

 DELETE FROM __sm_ext_mgmt WHERE type = "NamedQuery: query_name"

My attempts:

 DELETE FROM __sm_ext_mgmt WHERE type = "NamedQuery: Export Bookmarks to CSV" DELETE FROM __sm_ext_mgmt WHERE type = "NamedQuery: Export Bookmarks to CSV with

Date-Time "

 DELETE FROM __sm_ext_mgmt WHERE type = "Export Bookmarks to CSV" DELETE FROM __sm_ext_mgmt WHERE type = "Export Bookmarks to CSV with Date-Time"

I highlighted this table:

 __sm_ext_mgmt<br>

., Then I clicked the Browse and Search tab

I right-clicked on two where my queries / Delete / were, and they now disappeared from the list

There were many other things, the previous entries that I made.

03/11/14 I think I can remove this type (06/10/15 just leave it):
,, QueryHistory

But I need to save these 5 types:

 . . . StructTree:ExpandedCategories . . . StructTree:ExpandedObjects . . . StructTree:AttachedDb . . . Enabled . . . BrowseTree:ColState:table:_sm_ext_mgmt

Everything is still working fine

0
source

More articles:


All Articles