sql1.rar_Want It_radiowi1_sql update

select * from constant_table_item where constant_table_def_id=368 ORDER BY priority; --and priority<>1000 order by priority --229604 227141 230661 636967 200386 --select * from constant_table_item where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=200386 --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=229604; --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=227141; --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=230661; --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=636967; --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=200386; --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=370; --update constant_table_item set priority=1000 where constant_table_def_id=368 and CONSTANT_TABLE_ITEM_ID=371;