UPDATE `supplier` SET `supplierCode` = 'MYEG', `supplierCompanyNo` = '472638-X', `supplierName` = 'MY EG SDN. BHD.', `attention` = '', `line1` = 'Lot 8.02, Level 8, First Avenue,', `line2` = 'Persiaran Bandar Utama,', `line3` = 'Bandar Utama, Petaling Jaya,', `city` = '', `supplierPostCode` = '47800', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = '000974528512', `termsID` = '0', `supplierCountryID` = '458', `supplierStateID` = '1931', `linkedAPAccountID` = '36', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '0.00', `createdDate` = '2015-04-28', `approvalNo` = 0 WHERE `ID` =  '3'