UPDATE `comp_item_category` SET `code` = '01', `name` = 'Treated Water', `shortName` = 'TW', `description` = 'Sales of treated water', `companyID` = '3', `orderNo` = '1', `updateBy` = '76' WHERE `ID` =  '1'