I want to update multiple columns i tried it this way but unfortunately its not working can anyone help me out?

UPDATE business
    SET business_id=4,contact=Mario Luigi,position=plumber,
    SET business_id=3,email=www.grankelly.org,
    SET business_id=2,contact=Homer Simpson,position=Purchasing Engineer,address=1234 Main St,city=Springfield,state=IL,Postal=19382,phone=555-555-5555,email=www.cajundelights-midwest.com,
    WHERE

Answers


These need to be separate update statements because you can't update multiple records with different values. For example, you're updating business_id to different values, so each of those statements needs to be a separate query. You also need to put single quotes around your string values.

/*Query 1:*/
UPDATE business
        SET business_id=4,contact='Mario Luigi',position='plumber'
WHERE ...

/*Query 2:*/
UPDATE business
        SET business_id=3,email='www.grankelly.org' WHERE ...

/*Query 3*/
UPDATE business 
SET business_id=2,contact='Homer Simpson',position='Purchasing Engineer',address='1234 Main St',city='Springfield',[state]='IL',Postal='19382',phone='555-555-5555',email='www.cajundelights-midwest.com' WHERE ...

Need Your Help

get the string used by localizedStandardCompare when it did a comparison

objective-c cocoa-touch uitableview localization nsstring

I'm sorting an array by using localizedStandardCompare:, which gives me the objects sorted in the correct, localized order. Now I want to use them in the index for a UITableView, which means I need...

IIS 8.5 multiple DNS - same IP/port binding

iis web server iis-8.5

I am relatively new to setting up IIS: