Richard Jones' Log: MySQL. Ugh.

Thu, 01 Apr 2004

My latest with MySQL was this gem:

mysql> show tables;
+-----------------------+
| Tables_in_rounduptest |
+-----------------------+
| __words               |
| msg_files             |
+-----------------------+
2 rows in set (0.00 sec)

mysql> drop table __words;
ERROR 1051: Unknown table '__words'

The only way I could fix this was to delete the database from disk. Again.

Comment by Darryl on Thu, 01 Apr 2004

Richard.

My guess is that the '_' is a wildcard character and your getting your funkay MySQL behaviour from the use of the preceeding underscore.

You owe me big bucks if i'm right :)

http://medstat.med.utah.edu/medstat_ops/node67.html

Comment by Richard on Thu, 01 Apr 2004

Nope, _ is fine. That table (and plenty like it) are normally dropped ok, but in this instance, for some reason, it wasn't.

Comment by Darryl on Thu, 01 Apr 2004

I tried :)

Comment by Nelson Alvarez on Tue, 11 Jul 2006

Damn!... so, that's the only choice for avoiding that moron message about not finding a table mysql does not allow to create...

deleting "the .frm and so files"? Thanks for your help...