Are MySQL comments allowed on Databases hosted by Digital Ocean?

Posted July 27, 2020 508 views
DigitalOcean Managed MySQL Database

I receive this exception anytime when trying to add a comment on a database column or table:

add column label_data mediumtext NULL DEFAULT NULL COMMENT 'Shipping labels file encoded in base64' to table {{%orders}} ...Exception: SQLSTATE[42000]: Syntax error or access violation: 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 'COMMENT 'Shipping labels file encoded in base64'' at line 1

It this because of a user permission issue on the hosted MySQL?

Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!