メモ(その1)
用意するテーブル
mysql> desc tbl1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| p1 | int(11) | NO | PRI | 0 | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> desc tbl2;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| p1 | int(11) | NO | PRI | 0 | |
| p2 | int(11) | NO | PRI | 0 | |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
参考
http://dev.mysql.com/doc/refman/5.1/ja/stored-procedures.html
http://dev.mysql.com/doc/refman/5.1/ja/mysql-command-options.html