Illegal table names
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 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
Re: Illegal table names
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 knows how? 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 - 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
Illegal table names
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
RE: Illegal table names
Is it illegal to include spaces in a table name or column name? I do have a problem with mysqldump which doesn't include the ` character and thereby prevent me to restore databases with tablenames / column names with spaces. PS: DROP TABLE `Table Name` does work. Just remember that you have to use the character ` and not ´ or ' which gave me some problems in the beginning. 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: 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: 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 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 - 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 - 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
Illegal table names
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
Re: Illegal table names
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 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 - 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
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 the proper character `. What's the ASCII? 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
Re: Illegal table names
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 `. What's the ASCII? 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 - 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
RE: Illegal table names
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å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 the proper character `. What's the ASCII? 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 - 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
RE: Illegal table names
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 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 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 - 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
Illegal table names
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. 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