So I want to update into the incident number into each row. But as you see here multiple rows have the same id name. How would I make my update statement to update each row with the incident number even if there are multiple rows of the same id name as shown in the table. FYI each row will have a different incident number.
function updateIncidentNumber() {
const updateQuery = 'UPDATE `np-inventory-planning-thd.IPP_SLA.sla_table` SET pagerduty_incident_number=? WHERE start_date IS NOT NULL'
const options = {
query: updateQuery,
location: 'US',
params: [incident_number]
}