{"id":130348,"date":"2022-04-13T18:00:12","date_gmt":"2022-04-13T22:00:12","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130348"},"modified":"2025-02-04T14:38:48","modified_gmt":"2025-02-04T19:38:48","slug":"update","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/update","title":{"rendered":"Update"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Update<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

Sometimes it may be desired to not return records as the result of a query, or add new ones via an INSERT<\/code> statement, but instead to modify the values of existing data in a table. This can be accomplished using the UPDATE<\/code> statement in SQL.<\/p>\n\n\n\n

While the UPDATE<\/code> SQL command may only occasionally be used by a Data Analyst or Data Scientist in an ad hoc fashion, it is far more likely to appear in transactional SQL code or in that for data engineering work. Nonetheless, a savvy analyst should be able to read and understand what a SQL UPDATE<\/code> statement is doing.<\/p>\n\n\n\n

The SQL UPDATE<\/code> statement takes a general form as below:<\/p>\n\n\n\n

Code Example<\/span>