|
|
int=1
while [ $int -le 31 ]
do
echo "delete from idle_cell where first_result='2006-05-$int 00:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 01:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 02:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 03:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 04:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 05:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 06:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 07:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 08:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 09:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 10:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 11:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 12:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 13:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 14:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 15:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 16:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 17:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 18:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 19:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 20:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 21:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 22:00:00';" |dbaccess npmdb;
echo "delete from idle_cell where first_result='2006-05-$int 23:00:00';" |dbaccess npmdb;
int=`expr $int + 1`
done
| | |
阅读(508) | 评论(0) | 转发(0) |
