mgjj 发表于 2018-8-23 07:31:50

根据字段状态删除指定目录文件的shell脚本

# mysql -uroot -proot -e "use sne;select ContentID,PlayAddress,statusCode from del_video_file;"  
+-----------+---------------------------------------------------------------------+------------+
  
| ContentID | PlayAddress                                       | statusCode |
  
+-----------+---------------------------------------------------------------------+------------
  
|    128704 | http://xxx:17533/gdtv/sports/shi/hc2012051620.mp4 |          0 |
  
|    128705 | http://xxx:17533/gdtv/sports/shi/hc2012051621.mp4 |          0 |
  
|    128706 | http://xxx:17553/gdtv/sports/shi/hc2012051622.mp4 |          0 |
  
|    128707 | http://xxx:17553/gdtv/sports/shi/hc2012051623.mp4 |          0 |
  
+-----------+---------------------------------------------------------------------+------------+


页: [1]
查看完整版本: 根据字段状态删除指定目录文件的shell脚本