What is the SQL UPDATE statement?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the SQL UPDATE statement?
Rating:
The SQL UPDATE statement allows a user to update the current values in a database with new values. It contains three main clauses. The first clause specifies the table that requires an update, the second clause specifies the column name and the data values that will be inserted in place of the current values, and the third clause specifies the criteria for the records that will be updated. An example query is given below:
| {first clause} | |
| {second clause} | |
| {third clause} |
Rating:
Was this information helpful?
Other articles
- What is bandwidth?
- What is a help desk?
- What are banners?
- What is Digest authentication?
- What is an equijoin?