cQKtJeAx

1CREATE TABLE IF NOT EXISTS tests (
2    id INT AUTO_INCREMENT,
3    col INT NOT NULL,
4    row INT NOT NULL,
5    PRIMARY KEY (id)
6);
7
8truncate tests;
9
10DROP PROCEDURE if exists InsertProc;
11
12DELIMITER #                                            
13
14CREATE PROCEDURE InsertProc (IN p_row INT, IN p_col INT)
15BEGIN
16   IF EXISTS(SELECT 1 FROM tests WHERE `row` = 2 AND `col` = 2) THEN
17     BEGIN END;
18   ELSE
19     BEGIN
20      INSERT INTO tests(`col`,`row`) 
21        VALUES (p_row,p_col);
22     END;
23   END IF; 
24END #                                          
25
26DELIMITER ;
27
28
29CALL InsertProc(1, 2);
30CALL InsertProc(3, 4);
31CALL InsertProc(2, 2);
32CALL InsertProc(4, 2);
33
34
35
36select * from tests;