Skip to content

Instantly share code, notes, and snippets.

@danielestevez

danielestevez/debugsql.sql

Last active February 22, 2018 11:51
Show Gist options
  • Save danielestevez/26a27947b60baa741002 to your computer and use it in GitHub Desktop.
Save danielestevez/26a27947b60baa741002 to your computer and use it in GitHub Desktop.
Download ZIP
Utils for debugging triggers and procedures in SQL
Raw
debugsql.sql
DROP TABLE IF EXISTS `kinton`.`debug_msg`;
CREATE TABLE `debug_msg` (
`msg` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
INSERT INTO debug_msg (msg) VALUES (CONCAT('message: ',IFNULL(variable, 'NULL')));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment