I am new in sql. I am having writting query based on data
How can I write query to update row; I want to follow this format;
UPDATE `reports_attributes`
(`ConID`,`CheckServices`,`Attribute1`,`Attribute2`,`Attribute3`,`Attribute4`,`Attribute5`,`Attribute6`,`Attribute7`,`Attribute8`)
VALUES ('78','Execute Summary','criminality','color1','education','color5','employment_check_2','color7','report_status','color9')
WHERE ConID=78 AND ReportType='interim_report'
No comments:
Post a Comment