MySQL syntax

Question

Is it possible to create a procedure in a muscle like this - CREATE PROCEDURE sp_1() IF NOT EXISTS ? If not, how to do it?

Accepted Answer · 2012-12-29T23:05:32

This is possible. Just another method to find out if such a procedure already:

 IF NOT EXISTS(SELECT 1 FROM mysql.proc p WHERE db = 'имя_БД' AND name = 'sp_1') THEN CREATE PROCEDURE sp_1() BEGIN ..... END; END IF;

1 answer 1