Re^2: Database Re-Insert

The problem is the question, before I start. Is it going to overwrite the data for existing primary keys? I want the overwrite, instead of rejection or duplication. I like to update existing records with the new data.

--Artist

Comment on Re^2: Database Re-Insert Download Code

Replies are listed 'Best First'.
Re^3: Database Re-Insert by adrianh (Chancellor) on Feb 28, 2006 at 17:23 UTC
The problem is the question, before I start. Is it going to overwrite the data for existing primary keys? I want the overwrite, instead of rejection or duplication. I like to update existing records with the new data. Almost all databases provide some mechanism for updating tables without clearing them. Take a look at your local database's documentation. For MySQL and PostgreSQL take a look at `ALTER TABLE`. (and of course be sure to take backups before hand.)	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: Database Re-Insert
by adrianh (Chancellor) on Feb 28, 2006 at 17:23 UTC

The problem is the question, before I start. Is it going to overwrite the data for existing primary keys? I want the overwrite, instead of rejection or duplication. I like to update existing records with the new data.

Almost all databases provide some mechanism for updating tables without clearing them. Take a look at your local database's documentation. For MySQL and PostgreSQL take a look at ALTER TABLE.

(and of course be sure to take backups before hand.)

[reply]
[d/l]