Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

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..

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

```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")```

We later pass through the things defined up front (e.x. "Date1") into where clauses

e.x. ``, @thing:= IF(@thing2= s.Id, @thing + 1, 1) AS ranking``

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

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

Okay that's great, I'll ping them. Thank you!