fix pathname, import another sql examples

3 files changed, 32 insertions, 2 deletions

diff --git a/regress/mysql/HOW_TO_SETUP.txt b/regress/mysql/HOW_TO_SETUP.txt
index acb1606f..73b29643 100644
--- a/regress/mysql/HOW_TO_SETUP.txt
+++ b/regress/mysql/HOW_TO_SETUP.txt
@@ -21,8 +21,7 @@ Enter password:
 INSERT INTO user
 VALUES ('beth.fml.org','fukachan',Password('uja'),'Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N');
 
-# cat ~/w/cvs/fml/databases/examples/mysql-toymodel/toymodel.sql |\
-	sudo mysql -h localhost -p fml
+# cat toymodel.sql | mysql -h localhost -p fml
 
 
 ###
diff --git a/regress/mysql/drop.sql b/regress/mysql/drop.sql
new file mode 100644
index 00000000..f1f44d43
--- /dev/null
+++ b/regress/mysql/drop.sql
@@ -0,0 +1 @@
+drop table ml ;
diff --git a/regress/mysql/toymodel.sql b/regress/mysql/toymodel.sql
new file mode 100644
index 00000000..c35bebbd
--- /dev/null
+++ b/regress/mysql/toymodel.sql
@@ -0,0 +1,30 @@
+create table ml (
+	ml      char(64),
+	file    char(64),
+	address char(64),
+	off     int,
+	options char(64)
+);
+
+insert into ml
+values ('elena', 'actives', 'fukachan@sapporo.iij.ad.jp', 0, '');
+insert into ml
+values ('elena', 'members', 'fukachan@sapporo.iij.ad.jp', 0, '');
+
+insert into ml
+values ('elena', 'actives', 'fukachan@fml.org', 0, '');
+insert into ml
+values ('elena', 'members', 'fukachan@fml.org', 0, '');
+
+
+select * from ml ;
+
+select * from ml 
+	where address = 'kenken@nuinui.net'
+		and
+	file = 'actives' ;
+
+select * from ml 
+	where address = 'fukachan@nuinui.net'
+		and
+	file = 'actives' ;