[sqlite] SQL Syntax To Copy A Table

2015-03-30 Thread Dominique Devienne
On Thu, Mar 26, 2015 at 4:29 PM, Nigel Verity wrote: > My requirement is to take periodic snapshots of a names and addresses > table, to be stored in the same database as the master. > Perhaps also look into https://www.sqlite.org/backup.html, which doesn't qualify for "the same database", but

[sqlite] SQL Syntax To Copy A Table

2015-03-29 Thread Maurizio Trevisani
I suggest to use the CloneTable function Have a look at https://www.gaia-gis.it/fossil/libspatialite/wiki?name=CloneTable It copies the table and all of its triggers, indexes, etc. Maurizio 2015-03-26 16:35 GMT+01:00, John McKown : > On Thu, Mar 26, 2015 at 10:29 AM, Nigel Verity > wrote: >>

[sqlite] SQL Syntax To Copy A Table

2015-03-26 Thread Martin Engelschalk
Hi Nige, create table as select * from See also http://www.sqlite.org/lang_createtable.html Martin Am 26.03.2015 um 16:29 schrieb Nigel Verity: > Hi > > I know this must seem a fairly dumb question, but I can't find an easy way to > create a copy of table using just SQL. > > My requirement

[sqlite] SQL Syntax To Copy A Table

2015-03-26 Thread Nigel Verity
Hi I know this must seem a fairly dumb question, but I can't find an easy way to create a copy of table using just SQL. My requirement is to take periodic snapshots of a names and addresses table, to be stored in the same database as the master. The master table has one index - an

[sqlite] SQL Syntax To Copy A Table

2015-03-26 Thread John McKown
On Thu, Mar 26, 2015 at 10:29 AM, Nigel Verity wrote: > Hi > > I know this must seem a fairly dumb question, but I can't find an easy way to > create a copy of table using just SQL. > > My requirement is to take periodic snapshots of a names and addresses table, > to be stored in the same