Me neither. With SQLite3Explorer, the SQL statement:

insert into table01 select * from table02

works perfectly. Shum, you need to find the problem elsewhere... perhaps the data of table02 is already
in table01??

/R

On Sun, 29 Jan 2006 13:53:22 -0500, <[EMAIL PROTECTED]> wrote:

"shum [Ming Yik]" <[EMAIL PROTECTED]> wrote:
Hi Darren Duncan,

>you said "insert contents of your_table into your_table"

No,

insert into table01 select * from table02

the structure of table01 and table02 are same,
Table01 and table02 are different table within same structure,

No such bug within MSSQL or mySQL or PostgreSQL !

Only in Sqlite (Ihave test sqlite 3.X) ...

This bug is easy to find out ...


If the bug is so easy to find out, perhaps you could give
us an example.  I am unable to reproduce it.
--
D. Richard Hipp   <[EMAIL PROTECTED]>




Reply via email to