#! /usr/bin/sh
for i in {0..99};do
a=dm_pas_portrait_
b=$i
c=_alias
tab1=${a}${b}${c}
for i in {0..99};do
a=dm_pas_portrait_
b=$i
c=_alias
tab1=${a}${b}${c}
mysql -uuser -ppassword -S /home/mysql/dj/mysql.sock -D database -N -e "alter table $tab1 "
done