Re: Table damaged? And if so how to fix?
Posted by: Rick James
Date: April 12, 2014 02:23PM

Strange.

> Unfortunately, after some web searching I can't figure out what to do with this information.

Unfortunately, I have run out of ideas, other than the desparate ones:
* restart mysql (should take very few seconds);
* if that did not solve it, then reboot

Those _should_ not be necessary, but it does smell like that table is wedged somehow, and the wedging _may_ be in the OS, not MySQL.

Here is another "solution". (I admit that it is ugly in your case.)
Create a 'parallel' table with the same PK (ID) as `patients`, plus `MR` with the new VARCHAR(50) and copy the existing data from `patients` to the new table. Then change the code to JOIN to the new table whenever you need MR. INSERTs and UPDATEs will be messy. Then simply leave the old MR behind.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.