Wednesday, May 16, 2012

update in mysql need good statement

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