Home » RDBMS Server » Server Administration » update command
update command [message #371311] Mon, 02 October 2000 14:38 Go to next message
chandra
Messages: 31
Registered: October 2000
Member
what is the update command?

Report message to a moderator

Re: update command [message #371331 is a reply to message #371311] Wed, 04 October 2000 05:11 Go to previous message
LB
Messages: 13
Registered: September 2000
Junior Member
If you mean what's the syntax it's...
UPDATE tablename
SET field1 = new_value,
field2 = new_value...
WHERE condition

You can update the values in one or many fields. If you omit the where clause it will update the whole table.
Hope this helps.

Report message to a moderator

Previous Topic: IF statement
Next Topic: Another question......
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 11:16:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.