Try using:
drop table `resultat impl VT2001`;
-Original Message-
From: Håkan Elmqvist [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2001 9:34 am
To: [EMAIL PROTECTED]
Subject: Illegal table names
mysql> drop `resultat impl VT2001`;
ERROR 1064: You have an error in your SQL syntax
use DROP TABLE `resultat ...`
Best regards,
RTX Telecom A/S
Benny B. Simonsen
BB/Project Engineer
System Development
RTX Telecom A/S
Stroemmen 6
DK-9400 Noerresundby.
Phone.: +45 96 32 23 00
Fax.: +45 96 32 23 10
E-mail: [EMAIL PROTECTED]
Web: www.rtx.dk
> -Original Message-
> From: H
if all else fails shut the db down and go in your db directory and just
delete the data files ;-)
Håkan Elmqvist wrote:
>
> mysql> drop `resultat impl VT2001`;
> ERROR 1064: You have an error in your SQL syntax near 'resultat impl
> VT2001`' at line 1
> I don't seem to have the proper character
forward ticks
Håkan Elmqvist wrote:
>
> Thanks for your very rapid response but:
>
> mysql> show tables;
> +--+
> | Tables_in_test |
> +--+
> | personer |
> | resultat impl VT2001 |
> | tentamen_impl_vt2001 |
> +--+
ECTED]
Web: www.rtx.dk
> -Original Message-
> From: Colin Faber [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 10:14 AM
> To: Håkan Elmqvist
> Cc: [EMAIL PROTECTED]
> Subject: Re: Illegal table names
>
> you can try
>
>
> DROP TABLE
you can try
DROP TABLE `table name`;
Håkan Elmqvist wrote:
>
> By accident, I don't know how (perhaps microsoft played me a trick), I
> managed to create a table with a name containing spaces i. e. a useless
> table with an illegal name.
> Now would like to drop that table. Is there anyone w
