Hi
I’m trying to copy all the Data from one table to another table in the same database using the following:
INSERT INTO new_tableone (row1, row2)
SELECT row1, row2 FROM tableone
Now I’m not certain that this is the best way to do it but I also get the error message
“Duplicate entry 'sometext' for key 1”
This is not a links database and “new_tableone” is empty
Regards
minesite
I’m trying to copy all the Data from one table to another table in the same database using the following:
INSERT INTO new_tableone (row1, row2)
SELECT row1, row2 FROM tableone
Now I’m not certain that this is the best way to do it but I also get the error message
“Duplicate entry 'sometext' for key 1”
This is not a links database and “new_tableone” is empty
Regards
minesite