{"id":172,"date":"2024-08-21T06:33:19","date_gmt":"2024-08-21T06:33:19","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=172"},"modified":"2025-05-09T08:57:59","modified_gmt":"2025-05-09T08:57:59","slug":"sql-update","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-update\/","title":{"rendered":"SQL Update"},"content":{"rendered":"\n

The UPDATE in SQL is used to modify existing records in a table. It allows you to change one or more values in one or more rows of a table.<\/p>\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 Example<\/h2>\n\n\n\n
SQL Update Updating a Single Record Example<\/h3>\n\n\n\n
This query updates the contact_number to ‘555-9999’ for the patient with patient_id = 2 in the Patients table.<\/p>\n\n\n\n
UPDATE Patients\nSET contact_number = '555-9999'\nWHERE patient_id = 2;<\/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 Records Example<\/h3>\n\n\n\n
This query updates the status to ‘Rescheduled’ for all records in the Appointments table where the appointment_date is ‘2024-07-18’.<\/p>\n\n\n\n
UPDATE Appointments\nSET status = 'Rescheduled'\nWHERE appointment_date = '2024-07-18';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Update Multiple Columns Example<\/h3>\n\n\n\n
This query updates the contact_number to ‘555-1234’ and the dob (date of birth) to ‘1991-01-15’ for the patient with patient_id = 5 in the Patients table.<\/p>\n\n\n\n
UPDATE Patients\nSET contact_number = '555-1234', dob = '1991-01-15'\nWHERE patient_id = 5;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Update Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Update Labs<\/h2>\n\n\n\n