„Update (SQL)“ – Versionsunterschied

An '''UPDATE''' statement in [[SQL]] UPDATE statememt changes data in aone record (or more records) in a [[relational database management system]].

For the UPDATE to be successfullsuccessful, the user must have data manipulation privileges (UPDATE privilege) over the table or column, the updated value must not conflict with all the applicable constraints (such as [[primary keyskey]]s, unique indexes , CHECK constraints, and NOT NULL constraints).

UPDATE phone_bookT SET numberC1 ='+3592434343' 1 WHERE nameC2 ='Johnson, Albert J.'a'