这次要给客户安装测试ineedle设备，但是安装后不会立刻有数据显示，不能够全面的展示给用户web界面的一些信息。此时需要有一个公网服务器能够展示一下ineedle统计数据，但是公司58设备上没有流量了，近期的数据没有更新了，所以准备将数据库中实际数据抽出几天的更改一下日期，使其展示ineedle的web界面上。最新的七天数据是2015.07.27--2015.08.02这7天的数据，正好一个星期。计划是将2015.07.27-2015.08.02修改为2015.10.19-2015.10.25。

方法：

举例：
// 日期向后3天
update apache_5min_flow set record_date=adddate(record_date, 3) where record_date='2015-08-05';

// 日期向前3天
update apache_5min_flow set record_date=subdate(record_date, 3) where record_date='2015-08-05';

过程：

// 测试日期是否存在
select distinct record_date from apache_5min_flow where record_date between '2015-07-27' and '2015-08-02';

apache开头
update apache_5min_flow set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update apache_5min_request set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update apache_cpuload_info set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update apache_server_info set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

mysql开头
update mysql_concurrent_connections set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_connect_cache set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_connection_rate_and_abort set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_flow_info set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_index_cache set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_query_cache set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_query_throughput set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_server_info set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_table_lock set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update mysql_table_row_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

server开头
update server_cpuload_mon set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update server_cpuused_mon set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update server_interface_mon set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update server_memory_mon set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update server_storage_mon set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

bhv开头
update bhv_abnormal_detail set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_attack_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_attack_ip_c set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_incursion_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_incursion_ip_c set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_robot_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_robot_ip_c set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_spider_id set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_spider_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_spider_ip_detail set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update bhv_sum set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

dom开头
update dom_byte_count set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update dom_http set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update dom_http_copy set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update dom_packet_count set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';

from开头
update from_acl set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update from_area set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update from_host_acl set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update from_host_area set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update from_host_ip_5min_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update from_host_isp set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update from_isp set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

host开头
update host_bandwidth set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update host_byte_count set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_http set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_packet set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_raw set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_sess set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_sess_active set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_sess_c_fail set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_sess_long set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_sess_s_fail set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';
update host_sess_suc set date=adddate(date, 84) where date between '2015-07-27' and '2015-08-02';

iweb开头
update iweb_attack_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attack_ip_7days set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attack_ip_c set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attack_ip_c_7days set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attack_ip_c_trend set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attack_ip_trend set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attack_ip_week set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_attacked_url set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_client_area set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_client_area_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
iweb_client_browser？？？？？？？
iweb_client_duration？？？？？？？
iweb_client_isp？？？？？？？？？
iweb_client_os？？？？？？？？？
iweb_client_pages？？？？？？？
update iweb_complex_url_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_refer_host set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_refer_se_area set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_refer_search set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_refer_summary set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_refer_url set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_refer_word set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_7days set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_c set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_c_7days set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_c_trend set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_c_week set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_trend set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_ip_week set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_refer set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_robot_url set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_spider_7days set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_spider_id set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_spider_ip set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_spider_trend set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_spider_url set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_spider_week set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_summary set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update iweb_url_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

request开头
update request_rsp_success set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update request_rsp_summary set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

sla开头
update sla_level_delay set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update sla_level_delay_var set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update sla_level_problem set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update sla_level_troubleshoot set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

url开头
update url_delay_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update url_hits_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update url_long_delay_detail set record_time=adddate(record_time, 84) where record_time between '2015-07-27' and '2015-08-02';
update url_long_delay_time_5min set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';
update url_size_rank set record_date=adddate(record_date, 84) where record_date between '2015-07-27' and '2015-08-02';

注：

红色加"？"部分内容是之前就没有数据，需要自己手动填写的，因此不能用sql语句来修改。如果再次需要修改，只需按将此sql语句拷贝至文本文档中，修改适当的日期后，直接通过navicat客户端执行sql文件即可，特别注意需要修改的地方。

*******************************************************************************************************

2015-10-26 11:12 修改

介绍：

上边是把数据库中需要修改的表的相关更新sql语句记录下来。这次修改目的：是要在以后的每天都更新一下之前的数据。因为之前的有效数据时间是7天，所以以后每天都要将之前的7天数据的日期向后修改+1天，仍然保持7天的有效数据时间。但是不能每天都来执行这些sql语句，因此在这里写了简单的shell脚本，每天凌晨2点的时候自动更新一下数据库。但是有个弊端，比如说今天早上9点就能看到下午的数据，有点扯啊，不过也是为了给客户展示，就这样凑合着用吧。

脚本内容：

#!/bin/bash

cd
/var/dz_resource/run_sql_to_modify_db

DATE=`date +%Y-%m-%d`

echo
"today:$DATE"

YES_DATE=`date -d "-1 day" +%Y-%m-%d`

echo
"yesterday:$YES_DATE"

sed
-i "s/$YES_DATE/$DATE/g" modify_db_sql

mysql -uroot -piweb_compass_mysql iweb < modify_db_sql

echo
"update database successfully! `date`"

 

数据库sql文件：

update apache_5min_flow set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update apache_5min_request set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update apache_cpuload_info set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update apache_server_info set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update mysql_concurrent_connections set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_connect_cache set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_connection_rate_and_abort set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_flow_info set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_index_cache set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_query_cache set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_query_throughput set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_server_info set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_table_lock set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update mysql_table_row_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update server_cpuload_mon set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update server_cpuused_mon set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update server_interface_mon set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update server_memory_mon set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update server_storage_mon set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update bhv_abnormal_detail set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_attack_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_attack_ip_c set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_incursion_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_incursion_ip_c set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_robot_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_robot_ip_c set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_spider_id set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_spider_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_spider_ip_detail set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update bhv_sum set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update dom_byte_count set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update dom_http set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update dom_http_copy set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update dom_packet_count set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

 

update from_acl set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update from_area set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update from_host_acl set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update from_host_area set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update from_host_ip_5min_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update from_host_isp set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update from_isp set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update host_bandwidth set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update host_byte_count set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_http set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_packet set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_raw set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_sess set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_sess_active set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_sess_c_fail set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_sess_long set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_sess_s_fail set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

update host_sess_suc set
date=adddate(date,
)
where
date
between
'2015-10-19'
and
'2015-10-26';

 

update iweb_attack_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attack_ip_7days set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attack_ip_c set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attack_ip_c_7days set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attack_ip_c_trend set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attack_ip_trend set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attack_ip_week set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_attacked_url set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_area set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_area_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update iweb_complex_url_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_refer_host set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_refer_se_area set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_refer_search set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_refer_summary set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_refer_url set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_refer_word set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_7days set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_c set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_c_7days set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_c_trend set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_c_week set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_trend set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_ip_week set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_refer set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_robot_url set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_spider_7days set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_spider_id set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_spider_ip set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_spider_trend set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_spider_url set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_spider_week set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_summary set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_url_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update request_rsp_success set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update request_rsp_summary set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update sla_level_delay set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update sla_level_delay_var set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update sla_level_problem set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update sla_level_troubleshoot set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

 

update url_delay_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update url_hits_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update url_long_delay_detail set record_time=adddate(record_time,
)
where record_time between
'2015-10-19'
and
'2015-10-26';

update url_long_delay_time_5min set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update url_size_rank set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_browser set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_duration set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_isp set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_os set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';

update iweb_client_pages set record_date=adddate(record_date,
)
where record_date between
'2015-10-19'
and
'2015-10-26';