UPDATE `supplier` SET `supplierCode` = '23100', `supplierCompanyNo` = '1234568-A', `supplierName` = 'Syarikat Kontena Nasional', `attention` = 'Puan Aminah', `line1` = 'alamat 1', `line2` = 'alamat 2', `line3` = 'alamat 3', `city` = '', `supplierPostCode` = '', `email` = 'sss.aaa@hhh.my', `website` = 'http://www.salihin.com.my', `phoneNumber1` = '1244444', `phoneNumber2` = '', `fax` = '3243242', `generalNote` = 'general note', `gstRegNo` = '012356789012', `termsID` = '1', `supplierCountryID` = '458', `supplierStateID` = '1931', `linkedAPAccountID` = '0', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '0.00', `createdDate` = '1970-01-01' WHERE `ID` =  '20'