UPDATE `supplier` SET `supplierCode` = '3000-000', `supplierCompanyNo` = 'AUSGRID ', `supplierName` = 'AUSGRID TESTING AND CERTIFICATION', `attention` = 'MARTIN MULCHY ', `line1` = 'LANE COVE TESTING STATION (LCTS) 18 MARS ROAD', `line2` = 'LANE COVE WEST NSW 2066 AUSTRALIA ', `line3` = '', `city` = 'LANE COVE WEST', `supplierPostCode` = '2066.', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = '', `termsID` = '34', `supplierCountryID` = '36', `supplierStateID` = '225', `linkedAPAccountID` = '33136', `currencyID` = '1', `creditLimitAlert` = 0, `creditLimit` = '0.00', `createdDate` = '2015-07-27', `approvalNo` = 0 WHERE `ID` =  '266'