UPDATE `item` SET `companyID` = '1', `itemCode` = '331000200', `name` = 'A24 Plastic Chair', `description` = 'Plastic Chair - Red', `itemCategoryID` = '', `itemTypeID` = '22', `unitOfMeasureID` = '2', `editDescription` = 0, `itemStatusID` = '1', `reorderLevel` = '0', `incomeID` = '53', `cogsID` = '57', `inventoriesID` = '25', `inputTaxID` = '', `outputTaxID` = '', `supplierID` = 0 WHERE `ID` =  '7'