Thread
#prefect-community
    Jason Motley

    Jason Motley

    7 months ago
    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

    Kevin Kho

    7 months ago
    I guess the question is if
    pymysql
    does. What is your error?
    Jason Motley

    Jason Motley

    7 months ago
    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

    Kevin Kho

    7 months ago
    You stored proc has no parameters right?
    Jason Motley

    Jason Motley

    7 months ago
    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
    Kevin Kho

    Kevin Kho

    7 months ago
    I think this question is better for pymysql. I would suggest you create an issue there cuz they’d be able to help you way better
    Under the hood we just do this if you are using our task
    Jason Motley

    Jason Motley

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