18.7. Dropping Stored Routines


To drop a stored routine, use the DROP PROCEDURE or DROP FUNCTION statement.

 DROP PROCEDURE [IF EXISTS] proc_name DROP FUNCTION [IF EXISTS] func_name 

It is an error if the named routine does not exist. Include the IF EXISTS clause to generate a warning instead. (The warning can be displayed with SHOW WARNINGS.) IF EXISTS is a MySQL extension to standard SQL.



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net