Illegal table names

2001-09-20 Thread Håkan Elmqvist
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

Re: Illegal table names

2001-09-20 Thread Colin Faber
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

Illegal table names

2001-09-20 Thread Håkan Elmqvist
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';

RE: Illegal table names

2001-09-20 Thread Benny Bunk Simonsen
: 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

Illegal table names

2001-09-20 Thread Håkan Elmqvist
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; +--+ |

Re: Illegal table names

2001-09-20 Thread Colin Faber
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

Illegal table names

2001-09-20 Thread Håkan Elmqvist
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

Re: Illegal table names

2001-09-20 Thread Colin Faber
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 `.

RE: Illegal table names

2001-09-20 Thread Benny Bunk Simonsen
: 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

RE: Illegal table names

2001-09-20 Thread Andrew Murphy
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

Illegal table names

2001-09-20 Thread Håkan Elmqvist
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.