Procedure Language in MySQL

                     Procedure Language(PL)
                     **********************

mysql> delimiter //
mysql> CREATE PROCEDURE arul (OUT param1 INT)
    -> BEGIN
    -> select * from place_header;
    -> END
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> call arul(@a);
    -> //
+----------+------------+----------------------+-------------+
| place_id    | place_name | place_address           | bus_station |
+----------+------------+----------------------+-------------+
|        1        | madras       | 10, ptc road              | parrys          |
|        2        | madurai      | 21,canalbank road     | kknagar       |
|        3        | trichy          | 11, first cross road    | bheltown      |
|        4        | bangalore   | 15, first main road     | cubbon park |
|        5        | hyderabad  | 115,lake view road   | charminar     |
|        6        | thanjavur     | 12, temple road        | railway jn     |
+----------+------------+----------------------+-------------+
6 rows in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)