UPDATE `supplier` SET `supplierCode` = 'S01', `supplierCompanyNo` = '3432-T', `supplierName` = 'Supplier 01 Sdn Bhd', `attention` = 'En. Budiman', `line1` = 'No.444', `line2` = 'Jalan laksamana', `line3` = 'Tamana Laksamana 4', `supplierPostCode` = '58444', `email` = 'budi@supplier01.com.my', `website` = 'www.supplier.com', `phoneNumber1` = '00000000', `phoneNumber2` = '1111111', `fax` = '453534', `generalNote` = '', `gstRegNo` = '', `termsID` = '2', `supplierCountryID` = '458', `supplierStateID` = '1933', `linkedAPAccountID` = '28405', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '1.00', `createdDate` = '2014-01-01' WHERE `ID` =  '46'