UPDATE `supplier` SET `supplierCode` = 'SAM007', `supplierCompanyNo` = 'Samblaze', `supplierName` = 'Samblaze Ltd', `attention` = '', `line1` = '', `line2` = '', `line3` = '', `city` = '', `supplierPostCode` = '', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = '', `termsID` = '0', `supplierCountryID` = '458', `supplierStateID` = '0', `linkedAPAccountID` = '29733', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '0.00', `createdDate` = '2014-10-31' WHERE `ID` =  '73'