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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8

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.


Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Error parsing DDL for schema.table
392
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.