fabiom Posted September 22, 2006 Share Posted September 22, 2006 I recentry upgraded mysql to the 5.0.22 version. Now I have a database with 20 tables, and I can view them with SHOW TABLES. But when i try to do SELECT * FROM test, i receive the 1146 error: Table test doesn't exist. When I try to do DROP TABLE test, i receive ERROR 1051 (42S02): Unknown table 'test'. Any help?I can't drop the database because I don't have the privilegies to do so. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 25, 2006 Share Posted September 25, 2006 What does CHECK TABLES have to say? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.