Does Prefect with MySQL support this type of stored procedur

Question

Does Prefect with MySQL support this type of stored procedure I got an error when the code runs fine querying our database directly ``SET Date1 = MAKEDATE YEAR CURDATE 1 + INTERVAL QUARTER CURDATE QUARTER INTERVAL 1 QUARTER ` `SET procedure2 = bla bla` etc

Kevin Kho · Answer

I guess the question is if `pymysql` does What is your error

Jason Motley · Answer

```pymysql err ProgrammingError 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 SET includeLostPipeline = FALSE at line 2 ```

Kevin Kho · Answer

You stored proc has no parameters right

Jason Motley · Answer

We later pass through the things defined up front e x Date1 into where clauses

Jason Motley · Answer

e x `` thing = IF thing2= s Id thing + 1 1 AS ranking``

Kevin Kho · Answer

I think this question is better for pymysql I would suggest you create an issue <https github com PyMySQL PyMySQL |there> cuz they d be able to help you way better

Kevin Kho · Answer

Under the hood we just do <https github com PrefectHQ prefect blob 23f541b15de35d95a533cf706bd9cdb7d672bc64 src prefect tasks mysql mysql py L102 L120|this> if you are using our task

Jason Motley · Answer

Okay that s great I ll ping them Thank you