Re: Drop Table Problem

2005-09-28 Thread Eric Bergen
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

Drop Table Problem

2005-09-19 Thread xtcsuk
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

Re: DROP TABLE problem!

2001-05-31 Thread Miguel Angel Solórzano
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

RE: DROP TABLE problem!

2001-05-31 Thread Simon Green
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&#

DROP TABLE problem!

2001-05-31 Thread Vili Germic
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