Aspect-Oriented programming with AspectJの本の最後のほうにTomcatやMySQLやAntのインストール方法が書いてあって、設定するSQL文があったので記載

users.sql

CREATE TABLE users
(
name VARCHAR(20),
pass VARCHAR(20)
);

INSERT INTO users VALUES('john', 'john');
INSERT INTO users VALUES('bob', 'bob');
INSERT INTO users VALUES('jack', 'jack');


stories.sql

CREATE TABLE stories
(
category VARCHAR(50),
body TEXT
);

INSERT INTO stories VALUES ('HEALTH','Will we ...');
INSERT INTO stories VALUES ('HEALTH','Will the artificial ...');
INSERT INTO stories VALUES ('HEALTH','Will there be any ...');
INSERT INTO stories VALUES ('POLITICS','As 2002 gets under ...');
INSERT INTO stories VALUES ('POLITICS','With Democrats ...');
INSERT INTO stories VALUES ('POLITICS','Congress passed ...');
INSERT INTO stories VALUES ('ENTERTAINMENT','Who\'s going to ...');
INSERT INTO stories VALUES ('ENTERTAINMENT','Pop music is ...');


preferences.sql

CREATE TABLE preferences
(
name VARCHAR(20),
category VARCHAR(50)
);

INSERT INTO preferences VALUES ('john', 'ENTERTAINMENT');
INSERT INTO preferences VALUES ('john', 'POLITICS');
INSERT INTO preferences VALUES ('bob', 'ENTERTAINMENT');
INSERT INTO preferences VALUES ('bob', 'POLITICS');
INSERT INTO preferences VALUES ('bob', 'HEALTH');


使い方:
shell>mysql < script_name

これで指定したスクリプトが実行されます。