MySQL Syntax Error While Creating Stored Procedure

Question

I'm trying to write a stored procedure for the first time in MySQL on MySQL Workbench. For the life of me I can't seem to get the syntax to work... this is what I have:

CREATE PROCEDURE Add_Column()
BEGIN
IF NOT EXISTS (SELECT NULL FROM information_schema.COLUMNS WHERE table_name = `Users` AND table_schema = DATABASE() AND column_name = `CreatedTimestamp`)
    THEN ALTER TABLE `Users` ADD `CreatedTimestamp` timestamp NULL DEFAULT NULL
END

CALL Add_Column();

This is the error I'm getting: Error Code: 1064. 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 'END' at line 5

I'm running MySQL 8.0.19. Any help is appreciated!

Amit Verma · Accepted Answer · 2021-06-30 03:46:41Z

1

As per the syntax mention by MySQL if have modified. Try this

DELIMITER //
CREATE PROCEDURE Add_Column()
BEGIN
IF NOT EXISTS (SELECT NULL FROM information_schema.COLUMNS WHERE table_name = `Users` AND table_schema = DATABASE() AND column_name = `CreatedTimestamp`)
    THEN 
       ALTER TABLE `Users` ADD `CreatedTimestamp` timestamp NULL DEFAULT NULL ;
END IF;
END //
DELIMITER ;


CALL Add_Column();

answered Jun 30, 2021 at 3:46

Amit Verma

2,4882 gold badges12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Syntax Error While Creating Stored Procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related