mysql> DELIMITER $$
mysql>
mysql> DROP PROCEDURE IF EXISTS `dejan`.`print_message` $$
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> CREATE PROCEDURE `dejan`.`print_message`()
-> BEGIN
-> BEGIN
-> SELECT 'this is just a dummy message' AS 'Message';
-> END;
-> END $$
Query OK, 0 rows affected (0.02 sec)
mysql> DELIMITER ;
mysql> call dejan.print_message();
+------------------------------+
| Message |
+------------------------------+
| this is just a dummy message |
+------------------------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
http://www.baze-podataka.net/
- Database Consultant & DBA -
Certified MySQL 5.0 DBA
Oracle 9i OCP DBA
Oracle 10g OCP DBA