If you have group of "mysql" commands that need to be executed repeatedly, you can put them into a file, and run them from the file in "mysql" batch mode. Here is a batch file, templinks.sql, contains following commands:
USE wbtest;
INSERT INTO links VALUES (10, 'www.rnbold.com');
SELECT * FROM links;
To run this batch file, you need to follow this tutorial:
>cd mysqlbin
>mysql -u root < templinks.sql id name
1 www.rnbold.com
10 www.rnbold.com