Gossamer Forum: General: Databases and SQL: Data from one table to another table (minesite)

Gossamer Threads

Home : General : Databases and SQL :

Data from one table to another table

Mar 18, 2005, 12:24 AM

minesite

User (357 posts)

Mar 18, 2005, 12:24 AM

Shortcut

Data from one table to another table

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

Subject	Author	Views	Date
Data from one table to another table	minesite	8207	Mar 18, 2005, 12:24 AM

Re: [minesite] Data from one table to another table	dan	8045	Mar 18, 2005, 12:34 AM

Re: [dan] Data from one table to another table	minesite	7982	Mar 18, 2005, 1:39 AM

Re: [minesite] Data from one table to another table	Alex	7902	Mar 21, 2005, 2:23 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676