mysql信号灯数据导入

 

-- select * from MultiDataViewerInfo where Post='';
-- select * from MultiDataViewerInfo where Post='C04';

-- delete from MultiDataViewerInfo;

-- update MultiDataViewerInfo set Post='C04' where Post='';
-- update MultiDataViewerInfo set Date='2018-02-27' where Date='0000-00-00';

/*
set @rownum=0;
set @post='C04';
update MultiDataViewerInfo set Identity=CONCAT(@post,'_',(@rownum:=@rownum+1)) WHERE Post=@post;
select * from MultiDataViewerInfo where Post=@post;
*/