#! /bin/sh
if [ $# -lt 1 ];then
echo "error.. need args"
exit
fi
if [ "$1"x != "alter"x ];then
echo "usage alter_table.sh alter" #为了防止误执行脚本
exit
fi
mysql -uxxxx -pxxxx -e"alter table db_name.table_xxx modify column data varchar(1024);"
for dbId in `seq 0 9` #假设由于十个库,库名为db_0 ~ db_9
do
mysql -uxxxx -pxxxx -e"alter table db_${dbId}.table_name modify column data varchar(2048);"
mysql -uxxxx -pxxxx -e"alter table db_${dbId}.table_name add data int(10) unsigned default 0 after data_other;"
done
分库中如何修改表中的字段长度和增加一列
最新推荐文章于 2024-05-27 11:11:40 发布