UPDATE `supplier` SET `supplierCode` = 'N01', `supplierCompanyNo` = '23456-T', `supplierName` = 'Nagoya Sdn. Bhd.', `attention` = '', `line1` = 'Nagoya Tower', `line2` = 'Setiawangsa Business Park', `line3` = '', `city` = 'Setiawangsa', `supplierPostCode` = '53000', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = '', `termsID` = '1', `supplierCountryID` = '458', `supplierStateID` = '1933', `linkedAPAccountID` = '30347', `currencyID` = '1', `creditLimitAlert` = '1', `creditLimit` = '5000.00', `createdDate` = '2014-11-04' WHERE `ID` =  '80'