1. Sqlite Manager Download
2. Sqlite Browser

I'm confused on how I seem to fail at doing a simple update in SQLite. I've installed SQLite Manager in Firefox and I want to update the moz_places table there.

SQLiteManager is a database manager for SQLite databases. You can manage any SQLite database created on any platform with SQLiteManager. SQLiteManager displays an entire database in one window. Many operations do display dialog boxes to complete, but the main browsing and manipulation functions all happen in one window. The main window has a tab panel that takes you to Design, Manage, and SQL panels. From here, the Design panel lets you browse the objects in your database.

Sqlite Manager Download

I'm confused on how I seem to fail at doing a simple update in SQLite. I've installed SQLite Manager in Firefox and I want to update the mozplaces table there because we recently changed 'provider' and instead of clearing my whole history in Firefox I thought it would be nice if I could simply update the information so the history points to the new location. The idea is to run this code: UPDATE mozplaces SET url = REPLACE(url, '.old.com/', '.new.com/') When I press Run SQL I've got the impression that nothing happens even though the Last Error field shows 'not an error'. Maybe it's simply very fast? Nope, when I then go into the data I find that it did not update a thing and my places folder is still full with old.com urls. However, when I try UPDATE mozplaces SET url = REPLACE(url, '.old.com/', '.new.com/') WHERE id = 2458 it DOES update this one record. Naively assuming that the SQLite syntax requires a WHERE I then added UPDATE mozplaces SET url = REPLACE(url, '.old.com/', '.new.com/') WHERE id 0 but that didn't get me any results either.

Sqlite Browser

Does SQLite only allow singe-row updates? Looking around on the internet I do not see such a limitation, but otherwise I'm not sure what could be the issue. PS: I'm doing this on a copy of the /Profiles/ folder I found in%appdata%, not directly on the 'live' version. So locking should not be an issue either. OK, stupid me.

Turns out this failed because of the fact that I already had some records in there with the new.com url and my UPDATE would then cause conflicts. I've solved it by going this route: UPDATE mozplaces SET url = REPLACE(mozplaces.url, '.old.com', '.new.com') WHERE NOT EXITS ( SELECT. FROM mozplaces o WHERE o.url = REPLACE(mozplaces.url, '.old.com', '.new.com') ) It did take while to finish; making SQLite Manager unresponsive, but in the end it now shows things as I had hoped they would be.