How can i create Stored procedure in mysql from python?

Question

I am trying to use pymysql to create a stored procedure in mysql database. I have a file which contains the statements to create stored procedure. I am running the mysql queries line by line using cursor.execure(line). The Queries to create stored procedure runs fine on the db. But on python they are giving syntax error.

DELIMITER $$

USE `ipaybridge2`$$

DROP PROCEDURE IF EXISTS `masking`$$

CREATE DEFINER=`root`@`%` PROCEDURE `masking`()
BEGIN
 
 query statements;

END$$

DELIMITER ;

the error i get is this: You have an error in your SQL syntax; it seems the error is around: 'DELIMITER $ $ USE `ipaybridge2` $ $ DROP PROCEDURE IF EXISTS `masking` $ $ CREAT' at line 1

Booboo · Accepted Answer · 2021-07-23 11:40:58Z

3

pymsysql does not want the DELIMITER statements. So you should already be connected to a specific database and thus the USE statement should not be required. Just pass the following to cursor.execute as a separate command:

DROP PROCEDURE IF EXISTS `masking`

And then pass to cursor.execute as the next command:

CREATE DEFINER=`root`@`%` PROCEDURE `masking`()
BEGIN
 
 query statements;

END

See Error when trying to create stored procedure

answered Jul 23, 2021 at 11:40

Booboo

45.6k4 gold badges46 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

How can i create Stored procedure in mysql from python?

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