· 8 years ago · May 12, 2018, 02:12 AM
1DROP DATABASE IF EXISTS demo;
2CREATE DATABASE demo;
3USE demo;
4CREATE TABLE names (
5name VARCHAR(50) NOT NULL
6);
7INSERT INTO names
8VALUES ('Ivy'),
9 ('Monny');
10DROP PROCEDURE IF EXISTS test_condition;
11DELIMITER ^^
12CREATE PROCEDURE test_condition()
13BEGIN
14DECLARE unknown_table CONDITION FOR 1146;
15DECLARE CONTINUE HANDLER FOR unknown_table
16BEGIN
17SELECT 'The table was not found.';
18END;
19SELECT * FROM names_test;
20END
21^^
22DELIMITER ;
23CALL test_condition();