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 who
: 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 `table name`;
Håkan Elmqvist wrote
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 |
+--+
3 rows in
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 `.
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:
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