- 论坛徽章:
- 0
|
请各位帮忙搞定一下,在线等
我现在给你一段代码,帮忙加一下:
currentmonth=`date +%m`
currentyear=`date +%Y`
currentday=`date +%d`
tablename=`date +%Y%m%d`
currentdate=$currentyear-$currentmonth-$currentday
if [ `date +%m` -eq 1 ];
then oldmonth=`expr $currentmonth + 10`
oldyear=`expr $currentyear - 1`
else oldmonth=`expr $currentmonth - 1`
oldyear=$currentyear
fi
if [ `date +%d` -eq 31 ];
then oldday=28
else oldday=$currentday
fi
oldtablename=$oldyear$oldmonth$oldday
olddate=$oldyear-$oldmonth-$oldday
cd /local/mysql/bin
mysql -u akazam -p12345<<!
use edge;
CREATE TABLE detail_$tablename (
TS datetime NOT NULL default '0000-00-00 00:00:00',
FROM_NODE_NAME varchar(20) NOT NULL default '',
TO_NODE_NAME varchar(20) NOT NULL default '',
MinRTT decimal(6,2) default '0.00',
AvgRTT decimal(6,2) default '0.00',
MaxRTT decimal(6,2) default '0.00',
RTTRatio decimal(3,2) default '0.00',
Loss decimal(3,2) default '0.00',
Packet int(4) NOT NULL default '0',
TotalPacket int(6) default '0',
RttPacket int(6) default '0',
LossPacket int(6) default '0',
PRIMARY KEY (TS,FROM_NODE_NAME,TO_NODE_NAME,Packet)
) TYPE=MyISAM;
update detail_$oldtablename set TS="$currentdate" where TS="$olddate";
select * from detail_$oldtablename where TS like $currentdate into outfile '/local/home/ywang/sql.txt';
update detail_$oldtablename set TS="$olddate" where TS="$currentdate";
load data local infile '/local/home/ywang/sql.txt' into table detail_$tablename; |
|