FUDforum: Database discussions » Determining when to use INSERT or UPDATE

Home » General » Database discussions » Determining when to use INSERT or UPDATE

Show: Today's Messages :: Polls :: Message Navigator

Re: Determining when to use INSERT or UPDATE [message #20674 is a reply to message #20668]

Mon, 25 October 2004 11:43

JamesS

Messages: 275
Registered: July 2002
Location: Atlanta, GA

Karma:

Senior Member

UPDATE returns an error when it is not successful. If you issue an UPDATE and get an error then issue an INSERT. You may also want to look at REPLACE INTO as another way to do it.

Report message to a moderator

[Message index]

		Determining when to use INSERT or UPDATE By: Abraxa on Mon, 25 October 2004 02:50
		Re: Determining when to use INSERT or UPDATE By: JamesS on Mon, 25 October 2004 11:43
		Re: Determining when to use INSERT or UPDATE By: Abraxa on Tue, 26 October 2004 00:54
		Re: Determining when to use INSERT or UPDATE By: JamesS on Tue, 26 October 2004 03:20

Previous Topic:	Zero values in fields
Next Topic:	MySQL 4.1 released

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 06:55:54 GMT 2024

Total time taken to generate the page: 0.04510 seconds