UPDATE `supplier` SET `supplierCode` = 'KURNIA', `supplierCompanyNo` = '44191-P', `supplierName` = 'AMGENERAL INSURANCE BERHAD', `attention` = '', `line1` = 'Menara Kurnia, No. 9, Petaling Jaya, Selangor Darul Ehsan.', `line2` = 'Jalan PJS 8/9, Petaling Jaya, ', `line3` = '', `city` = '', `supplierPostCode` = '46150', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = '000789741568', `termsID` = '0', `supplierCountryID` = '458', `supplierStateID` = '1931', `linkedAPAccountID` = '36', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '0.00', `createdDate` = '2015-04-28', `approvalNo` = 0 WHERE `ID` =  '2'