MySQL Forums
Forum List  »  MySQL Workbench

Error parsing DDL for schema.table
Posted by: N BD
Date: January 29, 2019 06:35AM

I have production dbs using Mysql 5.5.31-0ubuntu0.12.04-1 (I know its old, will be upgraded soon).

I used a too advanced version of mysql workbench which allowed me to add a comment to key. (Now reverted to WB 6.3 which should be compatible with mysql 5.5)

Now when I 'Alter table' on one of the tables I get Error parsing DDL. When I click it shows the error is in the comment of the key (see below)

KEY `for cron (product ready)` (`a`,`b`),
KEY `subproducts` (`a`,`b`,`c`) COMMENT 'find products by the subproducts joiner'

The question is how can I remove the comment of the key without mysql rebuilding the table and without access to the mysql workbench alter table UI. This is an important production server and I would like to avoid alter table which will scan all the table.


Options: ReplyQuote

Written By
Error parsing DDL for schema.table
January 29, 2019 06:35AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.