Shell Programming and Scripting

ALTER TABLE `abc`  ADD PARTITION ( PARTITION 20130613 VALUES less than (DAY('13')));

ALTER TABLE `abc`  ADD PARTITION ( PARTITION 20130614 VALUES less than (DAY('14')));

perl -e 'use Date::Calc qw(:all);
for ($i=13;$i<=100;$i++) {
  ($y,$m,$d)=Add_Delta_Days(2013,05,31,$i);
  printf "ALTER TABLE `abc`  ADD PARTITION ( PARTITION %d%02d%02d VALUES less than (DAY(\047$i\047)));\n",$y,$m,$d
}'

#!/bin/sh
#
#Script to test for loop
#
#
if [ $# -eq 0 ]
then
echo "Error - Number missing form command line argument"
echo "Syntax : $0 number"
echo " Use to print multiplication table for given number"
exit 1
fi
a=$1
c=20130613
for i in 1 2 3 4 5 6 7 8 9 10

do
echo "ALTER TABLE seats  ADD PARTITION ( PARTITION $c VALUES less than (DAY( `expr $a \+ $i`)));"
c = expr $c + 1;
done

c=$(expr $c + 1)

c=$((c+1))

$uname -a
Linux ndbd1 2.6.18-238.el5 #1 SMP Thu Jan 13 15:51:15 EST 2011 x86_64 x86_64 x86_64 GNU/Linux