By LAstory2006
I have a MySQL stored proc that is running locally on MySQL 8 but is failing on my managed MySQL on DigitalOcean. The proc contains dynamic sql being built as a variable (@query), then executed by the following:
prepare st from @query; execute st; DEALLOCATE PREPARE st;
The error I get states the following:
1054 - Unknown column ’ [… my sql from @query var …] ’ in ‘field list’
It is clearly treating the entire sql statement as a column name instead of a statement that must be executed. This is not what happens on a local MySQL install.
The exact same code runs locally. Is this a permission issue? Lack of rights to EXECUTE? Disabled dynamic SQL?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.