Update (SQL),”Update a row in a table.General: update “”tablename””set “”columnname”” = “”newvalue”” [,””nextcolumn”” = “”newvalue2″”…]where “”columnname”” OPERATOR “”value”” [and|or “”column”” OPERATOR “”value””]; [] = optionalex. update phone_book set area_code = 623 where prefix = 979;update phone_book set last_name = ‘Smith’, prefix=555

Database
Average Rating
0 out of 5 stars. 0 votes.

Update (SQL),”Update a row in a table.General: update “”tablename””set “”columnname”” = “”newvalue”” [,””nextcolumn”” = “”newvalue2″”…]where “”columnname”” OPERATOR “”value”” [and|or “”column”” OPERATOR “”value””]; [] = optionalex. update phone_book set area_code = 623 where prefix = 979;update phone_book set last_name = ‘Smith’, prefix=555

suffix=9292 where last_name = ‘Jones’;”