MySQL table won't stay emptied

Mystery row remains after truncate or delete

[cschults]

I have a MySQL MyISAM table that has one row that I can't delete. I have tried:

1) Deleting the row
2) Truncating the table
3) Dropping the table and recreating it

For each method, even #3, the mystery record persists. I've tried repairing the table with no luck (it appears to be fine).

[cschults]

Another oddity: If I edit the ID of the mystery record, the edited version is added as a new row and the original mystery one is still there!

FYI: the ID column is a primary (and only) index.

[LifeinAsia]

Is it a foreign key with another table?

[cschults]

No, or at least it shouldn't be.

[LifeinAsia]

How are you creating the table?

[cschults]

I'm exporting the SQL for the table structure from the development version of the table using phpMyAdmin.

[cschults]

Also, if I move or copy the table to one with a different name, there are no issues.

[LifeinAsia]

Sounds like there might be a foreign key in a different table somewhere.

[LifeinAsia]

What if you copy the table to a new name, drop the first one, then copy the renamed table to the original name?

[cschults]

That did it, thanks! I hadn't tried that exact sequence. Now, why did this occur in the first place ... ?

[LifeinAsia]

My guess is that there's something in the table structure that you're exporting from development. Without knowing the exact structure, I can't say more. But if it works now, I'd say you're good to go!