UPDATE `supplier` SET `supplierCode` = 'ASFD45', `supplierCompanyNo` = 'comp2345', `supplierName` = 'Supplier 1', `attention` = '', `line1` = 'Kuala Lumpur', `line2` = '', `line3` = '', `supplierPostCode` = '', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = 'A234-A', `termsID` = 0, `supplierCountryID` = '458', `supplierStateID` = '1933', `linkedAPAccountID` = '0', `currencyID` = '1' WHERE `ID` =  '34'