At 3:32 PM +0800 1/29/06, shum [Ming Yik] wrote:
Hi Sqlite Team,
insert into disk.your_table select * from your_table;
There is an bugwithin insert into table01 select * from table02
Always double the inserted rows in table01 ...
where the structure of table01 and table02 are the same ....
I use Sqlite 3.3.2b
Your example code did not indicate that you were using 2 different
tables; you said "insert contents of your_table into your_table",
which would of course result in a doubling up. You need to use
different table names. Or if you have 2 database files having the
same named table, you need to say foo.your_table and bar.your_table;
leaving the prefix off one is ambiguous, so it could choose the one
in 'disk'. Try fixing your SQL and see if it works then. -- Darren
Duncan
