CRVM-redis-6/1420轧机振动数据库修改.txt

11 lines
460 B
Plaintext
Raw Permalink Normal View History

2025-11-07 02:02:31 +08:00
update t_coilinfo set origPath=replace(origPath, '\\', '\');
update t_coilinfo set energyPath=replace(energyPath, '\\', '\');
alter table t_alarm_info add standno int;
alter table t_alarm_info add energy float;
update t_coilinfo_client set origPath=replace(origPath, '\\', '\');
update t_coilinfo_client set energyPath=replace(energyPath, '\\', '\');
alter table t_alarm_info_client add standno int;
alter table t_alarm_info_client add energy float;