#!/bin/bash

records=1000

MYSQL_1="mysql --no-defaults -uroot --port=15999 --protocol=tcp test"

echo "dropping table t1"
$MYSQL_1 -e 'DROP TABLE t1'

sleep 5

echo "creating table t1"
$MYSQL_1 -e 'CREATE TABLE t1(i INT,j INT)ENGINE=INNODB'

echo "inserting $records records."
for ((i=1; i <= $records; i++)) do
$MYSQL_1 -e "INSERT INTO t1 VALUEs($i, 1)"
done

