===== ウォームアップ用スクリプト ===== #/bin/bash USR='root' PWD='password' for TABLENAME in `mysql -u ${USR} -p${PWD} -N -s -e "SELECT concat(TABLE_SCHEMA,\".\",TABLE_NAME) as TABLE NAME FROM information_schema.tables WHERE TABLE_SCHEMA like 'PREFIX_%' AND TABLE_TYPE = 'BASE TABLE' AND ENGINE = 'InnoDB';"`; do mysql -u ${USR} -p${PWD} -N -s -e "SELECT * FROM $TABLENAME;" > /dev/null done; ### ### -N: カラム名を出力しない ### -s: セパレータをタブに置換 ###