I'm using MySQL Workbench to remove rows from a table in my database. Most of the time, I will simply write a select statement, then select the rows I want to erase and use the
remove rows button (circled in the screenshot below).
But sometimes (quite often actually), the
remove rows button does not appear. Instead, I get something like the screenshot below:
remove rows button is not there and the
remove rows option is grayed out in the context menu, so basically, I can't remove rows... The only way I've found of solving this issue is to run the select query many times until the button appears (it usually does after 3 of 4 times).
Does anyone know why this is happening?
Today, I've been running a select query dozens of times and the button never appears. It seems my incomprehensible workaround no longer works... Help!
btw: Using a delete statement does work, though I would rather not have to write one for each row I want to remove as this happens quite frequently during development...