Tag Info

New answers tagged

0

The problem is, when you try to EXECUTE your DYNAMIC query the query returns NULL when there's not found rows. Test: mysql> CALL drop_tables_like( -> '6', #myint INT, -> 'onare', #pattern VARCHAR(255), -> 'PRUEBA'); #db VARCHAR(255)) +--------+ | sqlSTR | +--------+ | NULL | +--------+ 1 row in set (0.00 sec) Query OK, 0 rows ...


-1

Use DECLARE CONTINUE HANDLER FOR SQLSTATE '1064' use link https://dev.mysql.com/doc/refman/5.0/en/declare-handler.html @Vietyank Your procedure working fine.The message showing is not an error it is an warning. Example: I have created a Database Test1; mysql>Create Database Test1; ...



Top 50 recent answers are included