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 knows how?
H
Professor Håkan Elmqvist
Avdelningen för medicinsk
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
Thanks for your very rapid response but:
mysql show tables;
+--+
| Tables_in_test |
+--+
| personer |
| resultat impl VT2001 |
| tentamen_impl_vt2001 |
+--+
3 rows in set (0.00 sec)
mysql drop 'resultat impl VT2001';
: 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
I am sending this again since for some reasons undescores don't show up in
this forum. The third table name should read
tentamen_impl_vt2001 i.e. tentamen[underscore]implunderscore]vt2001 which
is legal.
Thanks for your very rapid response but:
mysql show tables;
+--+
|
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
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 `. What's the ASCII?
H
Professor Håkan Elmqvist
Avdelningen för medicinsk teknik
Institutionen för medicinsk laboratorievetenskap
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 `.
: Håkan Elmqvist [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 10:34 AM
To: [EMAIL PROTECTED]
Subject: Illegal table names
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
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
The character seems to be decimal 96 (enter it with Alt-96 on a PC).
Interestingly the command produces an error when the command is given
directly to mysql over a ssh connection but works fine when invoked with
Zeos Simple_mysql (http://www.zeoslib.org/zeos_zia_main.php ).
Thanks for the help.
11 matches
Mail list logo