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;
+----------------------+
| Tables_in_test |
+----------------------+
| personer |
| resultat impl VT2001 |
| tentamen_impl_vt2001 |
+----------------------+
3 rows in set (0.00 sec)
mysql> drop 'resultat impl VT2001';
ERROR 1064: You have an error in your SQL syntax near ''resultat impl
VT2001'' at line 1
mysql> drop "resultat impl VT2001";
ERROR 1064: You have an error in your SQL syntax near '"resultat impl
VT2001"' at line 1
H
Professor Håkan Elmqvist
Avdelningen för medicinsk teknik
Institutionen för medicinsk laboratorievetenskap & teknik
KAROLINSKA INSTITUTET
Novum
141 57 Huddinge
Tel 46-8-585 837 55, Fax 46-8-779 55 50
epost [EMAIL PROTECTED]
Organisationsno. 01 202100-2973 01
Vat No. SE 202100297301
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
