how to save in SQLite Manager?

I have opened a sqlite3 database file in firefox sqlite manager, made some changes to it but I can't see a way to save i开发者_Python百科t?

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

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

It's a database. The result of data affecting queries is saved as executed in the database, such as:

• CREATE TABLE
• ALTER TABLE
• DROP TABLE
• INSERT
• UDPATE
• DELETE

06/10/15 this page is no longer there . . . 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 a SQLite database and rerun at a later time from the Execute SQL tab of SQLite Manager.

To enable this functionality, go to the Tools menu in the Menu bar and check the Use Table for Extension Data item.

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

To retrieve the SQL query, select it by name from the drop down menu below the Enter SQL text box.

The text of the statement will be written to the Enter SQL text box where it can be modified if necessary before being run.

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

DELETE FROM __sm_ext_mgmt WHERE type = "NamedQuery: query_name"

I don't understand this syntax. Maybe I'm not entering it in the right place. None of these worked. I tried to run these like the query:

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>

. . . I then clicked the Browse & Search tab

I right-clicked on the two in there that were my queries / Delete / and they're gone from the list now

A lot of other stuff was in there, previous entries that I did.

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

But I need to keep these 5 types:

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

Everything still seems to be working properly

If you are using the data grid editor, then once the UPDATE query has run, the changes are ALREADY committed in the database.

If you are using the SQL area and typed your own UPDATE or DELETE statements: SQLite by default uses one-statement transactions; you can however manually start and end a transaction with BEGIN; and END; or COMMIT;.

So, if you ran an UPDATE or DELETE statement, it has been committed and you cannot rollback.

File -> Download active Database