Bulk modifying tables with shell scripts

Recently, because of the development of new features, the programmer needs to quickly add fields to all the tables in a library, so it is simple and quick to use shell scripts to add fields to the bulk modification table.

#!/bin/bashexport mysql_bin=/usr/local/mysql/binexport database=databaseexport tables= ' $mysql _bin/mysql-bse ' use ${ Database};show tables; " ' For I in ${tables} does $mysql _bin/mysql-bse "use ${database}; Alter table $i Add Column column_name decimal (8,2) default 0.00; " Done

This simply iterates through all the tables in the library with a for loop, making modifications to add

This article from "Technical essay" blog, declined reprint!

Bulk modifying tables with shell scripts