Home » RDBMS Server » Server Utilities » Database import including updates
Database import including updates [message #74194] Mon, 04 October 2004 23:19 Go to next message
Fiona
Messages: 4
Registered: December 2000
Junior Member
I need to do an import into a database that will include updated rows. What is the best way to do this ? Should we truncate or drop the affected tables first and then do the import ?

Report message to a moderator

Re: Database import including updates [message #74196 is a reply to message #74194] Tue, 05 October 2004 02:48 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Yes, you need to TRUNCATE or DROP the tables before re-importing them. If you don't, you might end up with duplicated rows.

Best regards.

Frank

Report message to a moderator

Previous Topic: SET coomand
Next Topic: migrate to different sid using import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 12 14:12:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.