#!/bin/bash

MYSQL="mysql -h10.20.30.40 -P3306 -uroot -pgeheim"

echo "DROP DATABASE Test;" | ${MYSQL} 2>/dev/null
cat /root/bin/Lasttest.sql | ${MYSQL}

seq 1 1000000 | while read Z
do
        echo "INSERT INTO Test.test (name,hash,content) VALUES ('${Z}','${Z}','${Z}');"
done | ${MYSQL}


echo "SELECT COUNT(*) FROM Test.test;" | ${MYSQL} -t