UPDATE `supplier` SET `supplierCode` = '0', `supplierCompanyNo` = '12345-D', `supplierName` = 'ahmad albab sdn bhd', `attention` = 'Ms Christina Lim', `line1` = 'no 6 jalan melor,', `line2` = 'taman melor antarabangsa,', `line3` = 'simpang pulai,', `supplierPostCode` = '68100', `email` = 'fana@yahoo.com', `website` = '0', `phoneNumber1` = '603-88891999', `phoneNumber2` = '', `fax` = '603-88891999', `generalNote` = '0', `gstRegNo` = '0', `termsID` = 0, `supplierCountryID` = '458', `supplierStateID` = '1931', `linkedAPAccountID` = '13', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '1234', `termstatus` = '5', `createdDate` = '2014-08-13' WHERE `ID` =  '1'