|
Home > Archive > MySQL ODBC Connector > September 2005 > Drop Table Problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Drop Table Problem
|
|
| xtcsuk 2005-09-19, 7:23 am |
| 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 complaints of this table already eixsts.
Please advise.
regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Eric Bergen 2005-09-28, 1:23 pm |
| 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 works just fine.
>
>Running a Show Table command lists table1 as an existing table and
>trying to create table1 complaints of this table already eixsts.
>
>Please advise.
>
>regards
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|