SITE SEARCH

Google
 

Monday, June 9, 2008

MySQL update Multiple Fields using UPDATE SET

Example:

Table Name: Empdet

UPDATE Empdet SET CNO='$mobil',PEMAIL='$emailid' ,LNO='$land',FATHUS='$fah',DOOR1='$door1',STREET1='$street1',LOC1='$loc1',CITY_DIST1='$dist1',STATE1='$state1',PIN1='$pin1',DOOR2='$door2',STREET2='$street2',LOC2='$loc2',CITY_DIST2='$dist2',STATE2='$state2',PIN2='$pin2',QUAL='$qual',AD_QUAL='$adqual' WHERE EID='$empid';

No comments: