{"id":1590,"date":"2024-09-04T06:57:56","date_gmt":"2024-09-04T06:57:56","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=1590"},"modified":"2025-06-09T06:17:26","modified_gmt":"2025-06-09T06:17:26","slug":"update","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/update\/","title":{"rendered":"UPDATE"},"content":{"rendered":"\n

SQL UPDATE Keyword<\/h2>\n\n\n\n

The UPDATE command is used to modify existing rows<\/strong> in a table. It allows you to change one or more column values for rows that match a specified condition.<\/p>\n\n\n\n

\n

Important:<\/strong> Be careful when using UPDATE<\/code> without a WHERE<\/code> clause \u2014 it will update all rows<\/strong> in the table.<\/p>\n<\/blockquote>\n\n\n\n

<\/p>\n\n\n\n

SQL UPDATE Syntax<\/h2>\n\n\n\n
UPDATE table_name\nSET column1 = value1, column2 = value2, ...\nWHERE condition;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL UPDATE Single Row Example<\/h2>\n\n\n\n
This query updates the specialty of the doctor with doctor_id = 1.<\/p>\n\n\n\n
UPDATE Doctors\nSET specialty = 'Dermatology'\nWHERE doctor_id = 1;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL UPDATE Multiple Rows Example<\/h2>\n\n\n\n
This query sets the gender of all patients with last name ‘Garcia’ to ‘Female’.<\/p>\n\n\n\n
UPDATE Patients\nSET gender = 'Female'\nWHERE last_name = 'Garcia';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL UPDATE Labs<\/h2>\n\n\n\n