Re: [sqlite] Why does the FAQ example use 2 copies for adding/deleting a column

Lothar Scholz <[EMAIL PROTECTED]> wrote: > Hello, > > The example for question 11 in the FAQ has this code for dropping an > existing table column 'c' > > BEGIN TRANSACTION; > CREATE TEMPORARY TABLE t1_backup(a,b); > INSERT INTO t1_backup SELECT a,b FROM t1; > DROP TABLE t1; > CREATE TABLE

[sqlite] Why does the FAQ example use 2 copies for adding/deleting a column

Hello, The example for question 11 in the FAQ has this code for dropping an existing table column 'c' BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; DROP TABLE t1; CREATE TABLE t1(a,b); INSERT INTO t1 SELECT a,b FROM t1_backup; DROP TABLE