需求库is_reserved_planning和last_reserved_planning状态字段为中文的刷新

select * from npas.de_cover_point where is_reserved_planning !=‘0‘ and is_reserved_planning !=‘1‘ and is_reserved_planning !=‘2‘ and is_reserved_planning !=‘3‘


and last_reserved_planning !=‘0‘ and last_reserved_planning !=‘1‘ and last_reserved_planning !=‘2‘ and last_reserved_planning !=‘3‘;





update npas.de_cover_point set is_reserved_planning=‘0‘ where is_reserved_planning=‘需求库‘;

update npas.de_cover_point set is_reserved_planning=‘1‘ where is_reserved_planning=‘储备库‘;

update npas.de_cover_point set is_reserved_planning=‘2‘ where is_reserved_planning=‘规划库‘;



update npas.de_cover_point set last_reserved_planning=‘0‘ where last_reserved_planning=‘需求库‘;

update npas.de_cover_point set last_reserved_planning=‘1‘ where last_reserved_planning=‘储备库‘;

update npas.de_cover_point set last_reserved_planning=‘2‘ where last_reserved_planning=‘规划库‘;