Use the INSERT/SELECT combo like this:
INSERT INTO dba (field1,field2,...) SELECT fielda,fieldb,... FROM dba WHERE
...
> Hi there,
>
> I have some data in one table which I have to move to another. No I thought
> of a mysqldump with a where clause. The problem though is, that it also
> tryes t
Hi there,
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth
