Unable to drop table

------=_NextPart_000_000E_01C7233A.3CB6B270
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: 7bit

Hi



When I view tables, I see 3 listed. When I say drop databases (the database
name), it says unknown table (the 3 tables). Even if I try drop the tables
themselves, it gives the same error.



Shaun van Wyngaard

Design Office (HOD)

Pressure Die Castings

033 397 5549 (Work)

084 596 1781 (Cell)

086 636 6504 (Fax)




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.23/591 - Release Date: 17/12/2006
03:17 PM


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


------=_NextPart_000_000E_01C7233A.3CB6B270--
Shaun van Wyngaard [ Di, 19 Dezember 2006 05:52 ] [ ID #1572422 ]

Re: Unable to drop table

When you login to the mysql command line are you specifying the database
name that the tables you want to drop are in? If not then you need to
enter the command: drop table database_name.table_name

And when you were trying to use drop database, were you entering DROP
DATABASE or DROP DATABASES ... there is no S at the end of it.

Armando

Shaun van Wyngaard wrote:
> Hi
>
>
>
> When I view tables, I see 3 listed. When I say drop databases (the database
> name), it says unknown table (the 3 tables). Even if I try drop the tables
> themselves, it gives the same error.
>
>
>
> Shaun van Wyngaard
>
> Design Office (HOD)
>
> Pressure Die Castings
>
> 033 397 5549 (Work)
>
> 084 596 1781 (Cell)
>
> 086 636 6504 (Fax)
>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
Dijital [ Di, 19 Dezember 2006 06:23 ] [ ID #1572423 ]
Datenbanken » gmane.comp.db.mysql.windows » Unable to drop table

Vorheriges Thema: MySQL on Win32
Nächstes Thema: ROOT access denied when altering privileges