Try running a flush tables in mysql to make sure that mysqld knows about
all the tables on disk.
xtcsuk wrote:
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it works just fine.
Running a Show Table command lists table1 as an existing table and
trying to create table1 complai
At 12:37 31/05/2001 +0200, Vili Germic wrote:
Hi!
The issue mentioned is relative to the Windows security privileges.
If the workstation connected or the local user doesn't has privileges
to delete files on the /mysql tree, that error message is launches.
Click over the MySQL folder icon with th
Just one thing I can think of..
Have you got GRANT privileges to drop DB?
Simon
-Original Message-
From: Vili Germic [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2001 11:37
To: [EMAIL PROTECTED]
Subject: DROP TABLE problem!
Hello everybody,
MySQL - 3.23.38 Win
MyODBC - 2.50.37
I
Hello everybody,
MySQL - 3.23.38 Win
MyODBC - 2.50.37
I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver.
2.50.37) to connect to db trought ODBC. Things works well, except for
dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC.
Trought SQL statement