create_table='
 CREATE DATABASE IF NOT EXISTS dbtest;
 USE dbtest;
 DROP TABLE IF EXISTS ttable;

 CREATE TABLE `ttable` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `foo` int(11) NOT NULL,

  PRIMARY KEY (id),
  UNIQUE KEY `index_unique` (`foo`)
) 
'
transaction1='INSERT INTO ttable (`foo`) VALUES (699422), (699421) ON DUPLICATE KEY UPDATE foo = VALUES (foo)'
transaction2='INSERT INTO ttable (`foo`) VALUES (699439), (699439) ON DUPLICATE KEY UPDATE foo = VALUES (foo)'

mysql -u root -e "$create_table"

for i in {1..100}; do
       mysql -u root dbtest -e "$transaction1" &
       mysql -u root dbtest -e "$transaction2"
done