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?
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.
Previous Topic: IF statement
Next Topic: Another question......
Goto Forum:
  


Current Time: Thu Mar 28 05:54:56 CDT 2024