Re: [sqlite] Performing multiple actions on a query

> > I know I can run the query again with a DELETE command, but what if > > the data has changed in between queries? > > Surround both statements with a BEGIN/COMMIT pair. Ahh, okay. That seems to do the trick. Thank you very much, Drake. ___ sqlite-use

[sqlite] Performing multiple actions on a query

I'm trying to move data between two databases. I found in the list archive the following solution from Chris Wedgwood: ATTACH DATABASE 'fromdb.sqlite' AS fromdb; [...] INSERT INTO fromdb.tablename SELECT * FROM src; This appears to *copy* data between databases, but I would like to then delete th