mysql按时间转存数据

mse吐出来的数据实在是太多了，所以按时间把数据转存出来。

#!/bin/bash

tablename='dump'`date -d "-1 day"   +%Y%m%d`
day='"'`date  +%Y-%m-%d`' 00:00:00''"'

echo $day

echo $tablename

echo "1.create table $tablename"
mysql -u root -pP@ssw0rd -e "use mse; CREATE TABLE ${tablename} like mse_rssidata;"


echo "2.dump data"


mysql -u root -pP@ssw0rd -e "use mse; INSERT INTO ${tablename} select * from mse_rssidata where mse_rssidata.insideTimestamp<${day};"

很简单的，构建表，insert就行了，最后在原来的表中删除数据

echo "3.erase data"
mysql -u root -pP@ssw0rd -e "use mse; delete  from mse_rssidata where mse_rssidata.insideTimestamp<${day};"

转载于:https://my.oschina.net/zwj0571/blog/332969