Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
DELIMITER $$ CREATE PROCEDURE `create_auditriggers` (IN database_needaudit VARCHAR(40)) BEGIN DECLARE a, b INT DEFAULT 5; DECLARE temptable VARCHAR(50); DECLARE today TIMESTAMP DEFAULT CURRENT_DATE; DECLARE v1, v2, v3 TINYINT; DECLARE tablelist VARCHAR(50); declare AAA cursor for SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='<database name>'; DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1; /*Specify what to do when no more records found, Notice that the handler declaration must appear after variable and cursor declaration inside the stored procedures*/ OPEN AAA; get_tabeslist: LOOP FETCH AAA INTO tablelist; IF finished = 1 THEN LEAVE get_tabeslist; END IF; print @tablelist END LOOP get_tabeslist; close AAA; END $$ DELIMITER ;
Lookup Error - MySQL Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.